If statement to add cells based on months.

[jsohng]

I was hoping someone could help me with this. I am trying to put in an If statement or a formula where the sum of the 2008 months would be added automatically based on the current month of the current year. So I would just want the sum for Jan 2008 - Oct 2008. The Months are a count field based on 2009.

I do not have a clue if there is a function out there that I can use that would suit my needs or make manual changes ongoing.



2008 2009 Dev. %
Calendar month 10 Months
JAN 200 220 -9%
FEB 150 150 -12%
MAR 125 160 -13%
APR 130 145 -17%
MAY 154 158 -20%
JUN 160 130 -24%
JUL 160 123 -25%
AUG 150 154 -26%
SEP 120 168 -34%
OCT 110 147 -59%
NOV 100
DEC 150


any help would be appreciated.

[JBeaucaire]

1) What is the formula you're using for the % calc in column D?

2) You can create formula that accumulates values from the rows above as it is copied down. For instance:
=SUM($B$3:$B3) / SUM($C$3:$C3)

Notice all the references are locked except the last row reference. As this is coped down, each row sums one row more than the previous row did. Perhaps this will help you?

[jsohng]

=COUNT(C3:C14) is the formula in column D for months

=SUM($C3:C$54)/SUM($B3:B$54)-1 is the formula for calculating deviations.


And what I am trying to get is the sum for 2008.

[DonkeyOte]

Might be an idea to post a sample so we can see the layout - quite hard to visualise. If you have 12 months I'm curious as to the 3:54 row range ?

Based on your initial post, perhaps (?) you want:

=SUM(B3:INDEX(B3:B14,COUNT(C3:C14)))

[jsohng]

That worked! Thanks alot. Sorry if i was not too clear or didn't put enough info up.