Help with SUMIF

[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

 

[Peo Sjoblom]

One way

=SUMIF(INDIRECT("F6:F27"),F5,INDIRECT("S6:S27"))