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