Sum,index,indirect

  • Thread starter Thread starter Rose Davis
  • Start date Start date
R

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
 
Hi
try something like the following
=SUM(OFFSET('actual02'!$A$2,0,0,84,MATCH(B1,'actual02'!$A$1:$N$1,0)))
 
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
 
Back
Top