H16 A B D E F G H J WNP Sales COUNT COUNTA Function to use 3 Date SalesRep 4 27 3 19 Kan 5 27 3 19 Bob 6 25 3 19 Kan 7 27 3 19 Bob 8 26 3 19 Kan 9 27 3 19 Lui 10 25 3 19 Lui 11 25 3 19 Kan 12 25 3 19 Lui 13 $800 $400 $900 $900 $400 $500 $800 $700 $500 14 15 16 17 18 Paste Merge Centre 00 $ v 9 Ideas Conditional Format Formatting as Table Cell Styles Format v Sort Filter Find Select C15 fx A B C D E F G J I 1 2 3 Sales 4 Function to use COUNT COUNTA SUM 5 6 7 Date Sales Rep 27 3 19 Kan 27 3 19 Bob 25 3 19 Kan 27 3 19 Bob 26 3 19 Kan 27 3 19 Lui 25 3 19 Lui 25 3 19 Kan 25 3 19 Lui 8 $800 $400 $900 $900 $400 $500 $800 $700 $500 9 10 When you specify a criteria or condition you are saying don't make the calculation on all the items, just on some of the items Function to use COUNTIFS Kan 27 3 19 SUMIFS 11 12 13 14 15 16 17 10 Paste V V SE Merge Centre $ v 00 0 Conditional F Formatting a 117 fx A B D E F G H J Invoice 1 Salesperson 2 Buchanan 3 Buchanan COUNTIF function for Buchanan COUNTIF function for Dodsworth 4 Suyama 5 Suyama 6 Buchanan 7 Dodsworth 8 Suyama 9 Buchanan 10 Dodsworth 15,000 9,000 8,000 20,000 5,500 7,000 13,000 6,000 4,000 12,000 1,000 2,300 4,500 8,000 6,400 4,000 2,000 11 Suyama 12 Suyama 13 Buchanan 14 Dodsworth 15 Buchanan 16 Suyama 17 Dodsworth 18 Dodsworth 19 ol t Merge Centre D3 A B D E F G H 1 Data 1 2 2 COUNTIF Answers 3 5 a 4 2 b 5 6 C 6 1 d 7 8 4 8 9 7 10 6 11 3 12 2 13 1 14 4 15 8 16 17 18 19 Formatting as lable Styles 110 A B C D E F G I J K Q4 Sales 1 Department 2 Produce 3 Produce 4 Produce 5 Meat 6 Meat 7 Meat 8 Deli 9 Deli 10 Deli 11 Bakery 12 Bakery 13 Bakery 14 15 16 Meat sold in Quarter 4 17 Category Vegetables Fruit Nuts Beef Chicken Fish Sandwich Soup Salad Specialities Breads Desserts Oct Nov Dec $ 28,041 $ 11,234 $ 10,910 $ 15,252 $ 18,397 $ 24,988 $ 17,063 $ 10,031 $ 19,463 $ 17,303 $ 30,984 $ 138,884 $ 20,155 $ 1,771 $ 17,985 $ 32,281 $ 26,101 $ 20,490 $ 29,230 $ 31,836 $ 28,931 $ 22,443 $ 16,856 $ 16,651 $ 19,439 $ 22,374 $ 29,728 $ 16,765 $ 23,270 $ 245,249 $ 19,579 $ 13,302 $ 29,683 $ 20,551 $ 26,037 $ 18,347

Question

H16 A   B D E F G H J WNP Sales COUNT COUNTA Function to use  3 Date SalesRep 4 27 3 19 Kan 5 27 3 19 Bob 6 25 3 19 Kan 7 27 3 19 Bob 8 26 3 19 Kan 9 27 3 19 Lui 10 25 3 19 Lui 11 25 3 19 Kan 12 25 3 19 Lui 13 $800 $400 $900 $900 $400 $500 $800 $700 $500 14 15 16 17 18 Paste   Merge   Centre  00 $ v   9 Ideas Conditional Format Formatting as Table Cell Styles Format v Sort   Filter Find   Select C15 fx A B C D E F G   J I 1 2 3 Sales 4 Function to use  COUNT COUNTA SUM 5 6 7 Date Sales Rep 27 3 19 Kan 27 3 19 Bob 25 3 19 Kan 27 3 19 Bob 26 3 19 Kan 27 3 19 Lui 25 3 19 Lui 25 3 19 Kan 25 3 19 Lui 8 $800 $400 $900 $900 $400 $500 $800 $700 $500 9 10   When you specify a  criteria  or  condition  you are saying   don't make the calculation on all the items, just on some of the items   Function to use  COUNTIFS Kan 27 3 19 SUMIFS 11 12 13 14 15 16 17 10 Paste V V SE    Merge   Centre $ v    00 0 Conditional F Formatting a 117 fx A B D E F G H   J Invoice 1 Salesperson 2 Buchanan 3 Buchanan COUNTIF function for Buchanan COUNTIF function for Dodsworth 4  Suyama 5 Suyama 6 Buchanan 7 Dodsworth 8 Suyama 9 Buchanan 10 Dodsworth 15,000 9,000 8,000 20,000 5,500 7,000 13,000 6,000 4,000 12,000 1,000 2,300 4,500 8,000 6,400 4,000 2,000 11 Suyama 12 Suyama 13 Buchanan 14 Dodsworth 15 Buchanan 16 Suyama 17 Dodsworth 18 Dodsworth 19 ol          t    Merge   Centre D3 A B D E F G H 1 Data 1 2 2 COUNTIF  Answers 3 5 a 4 2 b 5 6 C 6 1 d 7 8 4 8 9 7 10 6 11 3 12 2  13 1 14 4 15 8 16 17 18 19 Formatting as lable Styles 110 A B C D E F  G I J K Q4 Sales 1 Department 2 Produce 3 Produce 4  Produce 5 Meat 6 Meat 7 Meat 8 Deli 9 Deli 10 Deli 11 Bakery 12 Bakery 13 Bakery 14 15 16 Meat sold in Quarter 4 17 Category Vegetables Fruit Nuts Beef Chicken Fish Sandwich Soup Salad Specialities Breads Desserts Oct Nov Dec $ 28,041 $ 11,234 $ 10,910 $ 15,252 $ 18,397 $ 24,988 $ 17,063 $ 10,031 $ 19,463 $ 17,303 $ 30,984 $ 138,884 $ 20,155 $ 1,771 $ 17,985 $ 32,281 $ 26,101 $ 20,490 $ 29,230 $ 31,836 $ 28,931 $ 22,443 $ 16,856 $ 16,651 $ 19,439 $ 22,374 $ 29,728 $ 16,765 $ 23,270 $ 245,249 $ 19,579 $ 13,302 $ 29,683 $ 20,551 $ 26,037 $ 18,347

Accepted Answer

The Answer is in the image, click to view ...

Question

H16 A - B D E F G H J WNP Sales COUNT COUNTA Function to use: 3 Date SalesRep 4 27/3/19 Kan 5 27/3/19

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Standards And Audits For Ethics Management Systems The European Perspective

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question