Using Variables in the sum() function

[Roy Korb]

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

 

[John]

Hello Roy,

You need to use "Named Ranges". Take a look at Chip Pearson's article:

http://www.cpearson.com/excel/named.htm

Best regards

John

 

[Bob Phillips]

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)