I have a formula in one of my cells sumproduct(index(F2:G31,0,1),H2:H31)

So for instance up till now, the above formula considers all values from F2:F31, G2:G31 and H2:H31. The rows beneath these cells are empty for now.

How should I set the above formula such that if I enter a value in F32, G32 and H32, the above formula should change as:

sumproduct(index(F2:G32,0,1),H2:H32)

Then if I enter values in F33, G33 and H33, the above formula should run for:

sumproduct(index(F2:G33,0,1),H2:H33)

So whenever I add values in the following cells of column F,G and H, the above formula takes into account all the cells up till those cells.

I think I might need to use 'range' somehow but I am not sure about the exact formula.

I will be very grateful if I can get some help with this!