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
=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