Problem Summing a Column

[timbo1957]

Hi,

I am trying to sum a column using the following and the . Formula part I can't get right. If anyone could advise I would be grateful.

There are headings in row 1, the worksheet is 6827 rows long and the 6827th row already has total values in it but due to data being removed they are now wrong.

So I want to go to H6827 and sum H2 to H6826 (The bottom row is variable).

Please Login or Register  to view this content.

[Kenneth Hobson]

Please Login or Register  to view this content.