Help with SUMIF

  • Thread starter Thread starter Glen Mettler
  • Start date Start date
G

Glen Mettler

I have the following formula to calculate some numeric data:
=SUMIF(F6:F27,F5,S6:S27) (this is in cell S5)
the qualifying code is in column F and the numeric data to sum is in column
S

Problem. When I insert a row just below row 5, the formula in S5 changes
to:
=SUMIF(F7:F27,F5,S7:S27)

I will be adding data to the new row6 and I need it to become a part of the
calculation.
I need the formula to remain F6: and S6:

How can I do that?

Glen
 
Back
Top