Thanks Kaushik,
That works. Also what do I need to change if I want to put the sum in the row "Above" the data and not the row at the end. So eg my data range is from 2 to 15 and I want to put the sum in row 1.
empty cell (Sum goes here = 15)
5
10
empty cell (sum goes here = 40)
10
10...
Hi Faseeh,
What if the number of rows is not fixed, unlike the above example where the data is between row 1 -15. What if the number of rows is not set. Can it be modified to accommodate that , maybe make it a variable and lookup the number of rows used?
I have a similar problem and will...