I need help with a macro that will total the total column for a specific number (column A) and gives me the total beside the last entry



Please see this screenshot to make it clearer

Any help is appreciated

Thanks

This post was edited by WDZepplin on Aug 21 2013 02:52pm

how come you need a macro for this?

You can use =sum(click your stuff)

anyways, a countif until = "" will work -1

I agree, no macro needed unless you want this to update automatically with new data without having the sum cover the whole column. You can sum over an entire column (or row) though. It's done like this:

sum(A:A)
sum(1:1)