Hi,

Please find the attached excel sheet(template6.zip (9.7 KB)).

I want to calculate the Sum and Display it in the third row

right after Total column. But i am not sure how many records user may add in this case.

It may be 10 or 3000 not sure. Also, in between blank cells may come as well.

For ex: Year 2070 will have 10 values and 2065 will have 3000 values.

I have entered some sample data for those two columns for your reference.

So hope, here i need to write a sum formula/macro, which calculates dynamically, as and when he adds a value in a cell for a particular column.

I have referred the below link and still not able to find a way.

Please suggest a solution as soon as you can.

Regards,

Prathap