jackson2222
New Member
- Joined
- Jul 19, 2006
- Messages
- 41
This is probually a simple question.
I have this formula
=SUMIF(A5:A65536,TODAY(),H5:H65536)
row 5 is the top of my range. When I insert a new row at row 5, it changes the above formula to the 6 row being the start of the range.
=SUMIF(A6:A65536,TODAY(),H6:H65536)
Can I lock the formula to always keep the 5th row as the top row.
I have this formula
=SUMIF(A5:A65536,TODAY(),H5:H65536)
row 5 is the top of my range. When I insert a new row at row 5, it changes the above formula to the 6 row being the start of the range.
=SUMIF(A6:A65536,TODAY(),H6:H65536)
Can I lock the formula to always keep the 5th row as the top row.