Sum Two Columns

This works;

Please Login or Register  to view this content.

Yes, it totals every row, down to the last row. Given your first post, that seems to be what you wanted.

However, if your last row is a grand total of each column (and you don't want to total those) then change this;

Please Login or Register  to view this content.

to this;

Please Login or Register  to view this content.

Then instead of ;

Please Login or Register  to view this content.

set the rows as a fixed range. Something like;

Please Login or Register  to view this content.

Obviously you got a different code elsewhere, but I see nothing wrong with this new code you acquired. If you are getting extra zero's in some cells, then check the format of those cells. I'll bet your answer is there.

BTW, you don't need this line in the code, it does nothing;

Please Login or Register  to view this content.

Another observation ...
These lines do the same thing, but the line you have;

Please Login or Register  to view this content.

is based on older versions of excel.
This is a better way of doing the above and achieving the same result, but is more efficient (especially for the newer excel versions that have over 1 million rows).

Please Login or Register  to view this content.

Honestly, that code is bad. But as long as you're happy with it.
Your code line from above;

Please Login or Register  to view this content.

is a superfluous and garbled version of what I gave you in post #3, which was;

Please Login or Register  to view this content.

and don't get me started on that second line that you think is a gem!