=SUMIF In cell B27, to sum the total raise amount earned, enter a formula to sum the Raise Amt in cell range J6:J13 if the criteria in A27 is met. Use absolute references when necessary. Copy the formula through cell B29. Clipboard Cell Insert Font 5 Alignment Formatas Formatting Table Styles Styles Number B22 fa =COUNTIF(F6:F13,A22) A C D 1 G K 2 3 Painted Paradise Today's Date High Bonus S Low Deduct $ 2/11/2021 750 H Net Payroll Increase $ 13,232 Average Raise % 4.01% RESORT SPA 500 Years 5 Name HireDate Job Title Salary 6 Meda Rodate 3/14/2010 Spa Manager $ 71,500 7 Christy Istas 8/12/2009 Therapist $ 42,100 8 Jason Niese 8/12/2009 Massage Therapist $45,800 9 Paul Medina 2/1/2011 Coffee Shop Manager $35,000 10 Juanita Gomez 9/30/2007 Barista $ 29,900 11 Susan Brock 5/15/2010 Gift Shop Manager $ 37,200 12 Jay Groth 3/16/2007 Sales Associate $28,100 13 Kate Munson 6/4/2005 Sales Associate $ 28,700 14 Standard 15 Years Employed Raise % 16 0 2.50% 17 2 3,00% 18 5 3.50% 19 7 4,005 Employed 10 11 11 10 13 10 13 15 Raise Standard Low Final % New Recommend Raise % High Bonus Deduction Raise Amt Increase Salary High 4.00% S 750 s $3,610 5.05% $ 75, 110 Standard 4.00% S s $ 1,684 4.00% $ 43,784 Standard 4.00% S $ $ 1,832 4.00% $ 47,632 High 4.00% $ 750 $ $ 2,150 6.14% 37,150 Standard 4.009 s $ $ 1.196 4.00% 31,096 LOW 4.00% $ s 500S 988 2.66% $ 38,188 Low 4.00%IS S 500 s 624 2.22% $ 28,724 Standard 4.00% S $ $ 1.148 4.00% $ 29,848 Final % Increase Comparison Evaluations Payroll RE Type here to search o * ( hp on Paste A A 2 Weap Text BIU-BO-A E Merge Center Alignment Custom $ -% ! -99 Conditional Formats Cell Formatting Table Styles Number Styles insert Delete Format Clipboard Font CHE B27 H M N 10 Juanita Gomez 11 Susan Brock 12 Jay Groth 13 Kate Munson 14 9/30/2007 Barista 5/15/2010 Gift Shop Manager 3/16/2007 Sales Associate 6/4/2005 Sales Associate D $29,900 $37,200 $28,100 $28,700 E 13 10 13 15 Standard Low Low Standard G 4.00% $ 4.00KS 4.00 $ 4.00% s $ $ $ $ 1,195 500$ 988 Soos $ 1,148 4.00% S1,096 2.66% 38,168 2.22X $ 28,724 4.00% $ 29,840 Final increase Comparison 5% 22 Standard 15 Years Employed Raise % 16 0 2.50% 17 2. 3.00% 18 5 3.50% 19 7 4.00% 20 21 Raise Count 22 High 2 23 Standard 4 24 Low 25 26 Ralse Amount Total 27 High 20 Standard 29 Low 30 - IS WEDA BATE CHRISTIAN STAS NE PAUL JUANITA SUSAN MEDAGOMEA OO geon MUNSON Evaluations Payroll ti Type here to search