In cell O16 use the SUMIF function to determine the Total Gross Monthly Salary for employees from Department A? Format answer as comma style, 0 decimal.
What formula should I use?
. Home Insert B5 1 2 7 8 9 10 11 12 13 14 15 16 17 18 19 20 11 12 24 25 26 27 28 29 30 31 33 32 33 34 25 36 17 13 19 40 Paste 41 Excel File Edit View Insert Format Tools Data Window Help 5. ( Draw Page Layout Arial B I U A Cut Copy Format + x fx A Rele Ready UP EVPLOYEE ID 11011 11021 11026 11061 11080 11080 11091 11094 11:00 11:0 Ng 11:30 1145 11:5 11174 117 11AC 5 11AC 11212 11215 112 11228 STARTUP DEPARTMENT B D D D C D D C D G 15 D 8 Sled 0 8 D B U Kal Rumble became gassiz C D Gross Monthly Salary Bonus Frendy pers Weed Jenkinson Far elson piss May Ca sin Dece Kadza LAST NAVE Thorpean FATELE O 11 A+ A- ST 3 A TL FUNCTIONS Formulas Data Review View os 0$ 1.500.00 1,000.00 500.00 800.00 400.00 200.00 2.000 $ 4.000 $ 6.000 $ 8000 $ 11 201 Mapeto Francois Janet Jz3 Jz3 James FIRST NAVE GENDER Veton Stan Skandy B Jad Vajra Lion ades k E Jan Man ADVANCED FILTER F F V F V F F V V M r r F F W W W = F = Rating Bonus CITY Scatough Madale Richmond Hill asard Scatoru West Hill P Pichmond Hill Richmond Hill Viesissauga Scato zuver Sorry JUN Gendy Med V Mell Makta Scatenat Tank Mohl Mast H PIVOT 25 45 55 5$ 65 239 200.00 600.00 350.00 1,100.00 1,300.00 ON ON CA ON ON ON BC BC ON ON BC ON ON CON CIN HC ON CIN ON ON ON ON H WINGSVER S WITH 1X7 LOCSP: HGJ 325 VIEW OLD VDC 200 PROV POSTAL DATE HIRED DATE CERTIFIED RATING GODE V9V 129 VOY 129 LJE 1X3 VIEWS TY 187 KOA ZNJ 1416 LJ1X3 HIGA 252138 VEE 4P6 LSP 412 VEP 248 V45 24 VEE 4PB VSE 30 SMS310 Test 1 - Student File Final(1) (1) Owner To Wrap Taxt Merge & Centre Education Bonus 25 35 55 2-Jun-di 3-12-12 12-Sep-05 7-Jan-12 12 May 04 26 Jun 13 TA: 16 2-Feb 10 10-06 3-01-06 25-Jun-16 15- 15--12 226-5 28-Ap 21- 50 2244 20:08 23-Nov-8 + 300.00 600.00 1.100.00 1.300.00 1.500.00 tv 22-Jan- 21-Sep-12 154907 27 Jun 10 16 7 Feb 17 21-Nov-11 25-Jun-07 30-Nov-37 Hov-1 P-May-10 thansa 12-1 12-43 20-4-15 General 23-Jan-17 5 13-14 20-May-17 25-May-17 15-May-19 5-May- 1-J-438 15-10 K @ 6 3 2 4 2 4 2 4 7 1 1 2 3 5 8 6 3 %> % L Units Produced 2 3 1 6 EDUCATION 2 3 1 6 2 2 5 5 5 1 4 +0 4 3 4 5 2 4 os 1,000 $ 1,300 $ T JAD M Bonus | 400.00 300.00 1,200.00 1,900.00 2,000.00 AGE 46 56 24 41 (2 80 67 21 48 35 13 50 53 13 Conditional Format Formatting as Table 63 SO A N Anawara VARRIED? O 40 NO YES YES YES YES YES YDS YDS YES 40 YES 40 YES 40 YES 8 BC VB ON ac Cell Styles a Province Bonus 1,899 1,997 1.136 1,772 1,379 1,704 www 1,832 1,236 1,055 UNITS GROSS PRODUCED NONTHLY SALARY 1,133 1,245 30 ... 1,26 1,200 1,490 1,393 $ $ 1,200.00 $ $ 1.300.00 1.100.00 1.225.00 1,175.00 15 Insert 5 $ N 1505 378 2,782 6041 5,478 5,198 3,554 3,382 7.383 9,442 4.661 7,660 3,196 www 8.365 2.288 9.375 2.570 9215 3.302 3.887 2.331 x Delete D 12 rave I+ 1001 C Format R Age Q2. Thu 23 Jun 1:40 PM Q Search Sheet 33 $ 47$ 30$ Auto-sum " Fill Clear 5 Bonus YEARS OF YEAR CERTIFIED MONTHOF HIT SERVICE 300.00 G00.00 700.00 300.00 900.00 A + Share A AY. Q. Sort & Filter Find & Select IF FUNCTION U | Departme A B C NESTED F 85% . Home Insert B5 1 2 7 8 9 10 11 12 13 14 15 16 17 18 19 20 11 12 24 25 26 27 28 29 30 31 33 32 33 34 25 36 17 13 19 40 Paste 41 Excel File Edit View Insert Format Tools Data Window Help 5. ( Draw Page Layout Arial B I U A Cut Copy Format + x fx A Rele Ready UP EVPLOYEE ID 11011 11021 11026 11061 11080 11080 11091 11094 11:00 11:0 Ng 11:30 1145 11:5 11174 117 11AC 5 11AC 11212 11215 112 11228 STARTUP DEPARTMENT B D D D C D D C D G 15 D 8 Sled 0 8 D B U Kal Rumble became gassiz C D Gross Monthly Salary Bonus Frendy pers Weed Jenkinson Far elson piss May Ca sin Dece Kadza LAST NAVE Thorpean FATELE O 11 A+ A- ST 3 A TL FUNCTIONS Formulas Data Review View os 0$ 1.500.00 1,000.00 500.00 800.00 400.00 200.00 2.000 $ 4.000 $ 6.000 $ 8000 $ 11 201 Mapeto Francois Janet Jz3 Jz3 James FIRST NAVE GENDER Veton Stan Skandy B Jad Vajra Lion ades k E Jan Man ADVANCED FILTER F F V F V F F V V M r r F F W W W = F = Rating Bonus CITY Scatough Madale Richmond Hill asard Scatoru West Hill P Pichmond Hill Richmond Hill Viesissauga Scato zuver Sorry JUN Gendy Med V Mell Makta Scatenat Tank Mohl Mast H PIVOT 25 45 55 5$ 65 239 200.00 600.00 350.00 1,100.00 1,300.00 ON ON CA ON ON ON BC BC ON ON BC ON ON CON CIN HC ON CIN ON ON ON ON H WINGSVER S WITH 1X7 LOCSP: HGJ 325 VIEW OLD VDC 200 PROV POSTAL DATE HIRED DATE CERTIFIED RATING GODE V9V 129 VOY 129 LJE 1X3 VIEWS TY 187 KOA ZNJ 1416 LJ1X3 HIGA 252138 VEE 4P6 LSP 412 VEP 248 V45 24 VEE 4PB VSE 30 SMS310 Test 1 - Student File Final(1) (1) Owner To Wrap Taxt Merge & Centre Education Bonus 25 35 55 2-Jun-di 3-12-12 12-Sep-05 7-Jan-12 12 May 04 26 Jun 13 TA: 16 2-Feb 10 10-06 3-01-06 25-Jun-16 15- 15--12 226-5 28-Ap 21- 50 2244 20:08 23-Nov-8 + 300.00 600.00 1.100.00 1.300.00 1.500.00 tv 22-Jan- 21-Sep-12 154907 27 Jun 10 16 7 Feb 17 21-Nov-11 25-Jun-07 30-Nov-37 Hov-1 P-May-10 thansa 12-1 12-43 20-4-15 General 23-Jan-17 5 13-14 20-May-17 25-May-17 15-May-19 5-May- 1-J-438 15-10 K @ 6 3 2 4 2 4 2 4 7 1 1 2 3 5 8 6 3 %> % L Units Produced 2 3 1 6 EDUCATION 2 3 1 6 2 2 5 5 5 1 4 +0 4 3 4 5 2 4 os 1,000 $ 1,300 $ T JAD M Bonus | 400.00 300.00 1,200.00 1,900.00 2,000.00 AGE 46 56 24 41 (2 80 67 21 48 35 13 50 53 13 Conditional Format Formatting as Table 63 SO A N Anawara VARRIED? O 40 NO YES YES YES YES YES YDS YDS YES 40 YES 40 YES 40 YES 8 BC VB ON ac Cell Styles a Province Bonus 1,899 1,997 1.136 1,772 1,379 1,704 www 1,832 1,236 1,055 UNITS GROSS PRODUCED NONTHLY SALARY 1,133 1,245 30 ... 1,26 1,200 1,490 1,393 $ $ 1,200.00 $ $ 1.300.00 1.100.00 1.225.00 1,175.00 15 Insert 5 $ N 1505 378 2,782 6041 5,478 5,198 3,554 3,382 7.383 9,442 4.661 7,660 3,196 www 8.365 2.288 9.375 2.570 9215 3.302 3.887 2.331 x Delete D 12 rave I+ 1001 C Format R Age Q2. Thu 23 Jun 1:40 PM Q Search Sheet 33 $ 47$ 30$ Auto-sum " Fill Clear 5 Bonus YEARS OF YEAR CERTIFIED MONTHOF HIT SERVICE 300.00 G00.00 700.00 300.00 900.00 A + Share A AY. Q. Sort & Filter Find & Select IF FUNCTION U | Departme A B C NESTED F 85%
