Use a dynamic range

=SUM(OFFSET($A$2,,,COUNTA($A:$A)-1,COUNTA($2:$2))

will sum from A2 across and down.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Roy Korb" wrote in message
...
I export Quickbook reports to Excel spreadsheets they are of various
nnumber of columns and various number of rows. I want to use macros with
variables in the =sum() functions rather than the hard cell address. Is
this
possible and if so how do I do it?

Thanks

Roy Korb