Sum,index,indirect

[Rose Davis]

Hello,
I can't figure out which one to use. I have several worksheets. First one
Actual 02 Across the top Jan - Dec. Rows are corresponding $ amounts to
account#'s. What I want to do is accumulate on a separate worksheet amounts
for Jan-March,etc if I type in March in cell b1. The formula I used and am
unable to get it to work again is
=sum(Actual02!c3:index(actual02!$A$1:$n$85,row(),column,(indirect($B$1)))).
What this did was whatever date I put in b1 on that cell c3, it would add
all the months up to and including the month in b1.

Thanks for any help
Rose Davis

 

[Frank Kabel]

Hi
try something like the following
=SUM(OFFSET('actual02'!$A$2,0,0,84,MATCH(B1,'actual02'!$A$1:$N$1,0)))

 

[Peo Sjoblom]

Something like this should work

=SUM(OFFSET('Actual 02'!$A$1,,,85,MATCH($B$1,'Actual 02'!$A$1:$L$1,0)))

replace 85 with the height of the table that you want to sum, I used 85
since I noticed
you had it in your formula, I am assuming that numeric data is in A2:L85
(A1:L1 = Jan - Dec)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom