I need help with formula for this question

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.

Tables Add-ins Charts Tours Sparklines Filters Links Comments C32 : X B C D F G K L M N 0 1 2 3 Painted Paradise E Today's Date High Bonus $ Low Deduct $ 1/2/2021 750 500 H 1 J Net Payroll Increase $ 10,451 Average Raise % 3.20% RESORT & SPA 4 Years Employed 10 11 - - 11 9 Raise Standard Low Final % New Recommend Raise % High Bonus Deduction Raise Amt Increase Salary High 3.00% $ 750 $ $ 2,895 4.05% $ 74,395 Standard 3.00% $ $ - $ 1,263 3.00% $ 43,363 Standard 3.00% $ - $ $ 1,374 3.00% $ 47,174 High 2.50% $ 750 $ - $ 1,625 4.64% $ 36,625 Standard 3.50% $ - $ - $ 1,047 3.50% $ 30,947 Low 3.00% $ $ 500 $ 616 1.66% $ 37,816 Low 3.50% $ $ 500 $ 484 1.72% $ 28,584 Standard 4.00% $ $ $ 1,148 4.00% $ 29,848 13 10 13 15 - Final % Increase Comparison 5% 4% 5 Name HireDate JobTitle 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.00% 20 21 Raise Count 22 High 23 Standard 24 Low 25 26 Raise Amount Total 27 High 28 Standard 29 Low 30 31 32 221 3% 2% 1% FINAL % INCREASE 13/14/2010 18/12/2009 18/12/2009 2/1/2011 19/30/2007 05/15/2010 3/16/2007 16/4/2005