Question: Consider the Excel spreadsheet below. Please select the Excel formula that sums up the number of all fraud goods sold by sellers from Germany. A

 Consider the Excel spreadsheet below. Please select the Excel formula that

Consider the Excel spreadsheet below. Please select the Excel formula that sums up the number of all fraud goods sold by sellers from Germany. A B D E F G H 1 1 Products.PID Products.Product Name Products.Price Products.SID Sellers.Name Sellers.Country Sellers.CREATED Category no_sold 2 001 Rolec Datejust (no fake) 10 02 Mrs McFake Singapore 2021-04-02 Counterfeit 212 3 002 Gnucci Handbag (original, no fake) 5 02 Mrs McFake Singapore 2021-04-02 Counterfeit 108 4 003 Marketing exam solutions 1500 03 Fremdkapital Bro Germany 2021-04-13 Stolen goods 254) 5 004 Banking Internship Certificate 800 01 Gordon Lizard USA 2021-03-27 Fraud 164 6 005 Fake title (Dr., von, Frst, ...) 3500 03 Fremdkapital Bro Germany 2021-04-13 Fraud 25 7 006 Financial mathematics 2021 Solutions!! 140 04 Khashoggi Jr. UAE 2021-04-22 Stolen goods 20 8 007 statistics introduction 2021 Solutions!! 200 04 Khashoggi Jr. UAE 2021-04-22 Stolen goods 4 9 008 1 take your GMAT for you! 780 avg score 500 05 Lil Einstein Germany 2021-05-04 Fraud 7 10 009 Adobe Photostore Original License 4. 02 Mrs McFake Singapore 2021-04-02 Counterfeit 29 11 010 Selfmade vodka (high quality!!!) 10 06 31 Gehweggruppe Germany 2021-05-06 Counterfeit 1045 12 011 Covid-20 (lab-grown) 30000 07 Department 12345 North Korea 2021-05-09 Weapon 0 13 012 Spreme Cap (original, no fake) 10 02 Mrs McFake Singapore 2021-04-02 Counterfeit 247 O =SUMIFS(12:113;H2:H13;"Fraud";F2:F13;"Germany") O=IF(AND(F2:F13 ="Germany";H2:H13="Fraud");SUM(12:113);0) =ADDIFS(12:113;H2:H13;"Fraud";F2:F13;"Germany") =SUMIF(12:113;H2:H13;"Fraud";F2:F13;"Germany")

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!