Increment additional INDEX row number when inserting rows above

[seanpears99]

Hi all

I have multiple INDEX sum ranges (3) and when I insert a line using a macro to the top table, the subsequent row starting points remain the same and do not increment, any idea I whenever I insert a line subsequent rows will increment automatically?

INDEX issue.jpg

This is the forumla I am using for the first table

=SUM(INDEX(BB:BB, 5):INDEX(BB:BB, ROW()-1))

and this for the second

=SUM(INDEX(BB:BB, 18):INDEX(BB:BB, ROW()-1))

But 18 doesnt move when I insert lines?

Any help is appreciated.

Thanks
Sean

[samba_ravi]

use Row(B5) instead of 5 and Row(B18) instead of 18

[seanpears99]

use Row(B5) instead of 5 and Row(B18) instead of 18

Thanks Siva but when I try that it says I have entered to few arguments?

[samba_ravi]

=SUM(INDEX(BB:BB, row(B5)):INDEX(BB:BB, ROW()-1))
=SUM(INDEX(BB:BB, row(B18)):INDEX(BB:BB, ROW()-1))
Try like above

[seanpears99]

Genius, thank you very much Siva