Progressive Sum Based on Variable.

[robert_shindorf]

ok, this may be the same answer as the previous post i did, but if so, i can't figure that part out.

In O2, if M2 = 8, and N2 = 2008, then add O3 + 8 rows (O3:O10)

or, if M2 = 5, and N2 = 2009 then add O16 + 5 rows (O16:O20).

I'm ready for a simple solution that I don't understand, lol.

[davesexcel]

Try,
=IF(AND(M2=8,N2=2008),SUM(O3:O10),IF(AND(M2=5,N2=2009),SUM(O16:O20),""))

[robert_shindorf]

oops, i don't think i explained it properly...

ok, m2 will vary, it's linked to a different worksheet.... and dependent on it's value, depends on the number of rows needed. (if it's a 3, 3 rows, it it's a 9, 9 rows).

if it's 2008 in n2, then start counting the rows at o3, if it's 2009, then start at o16.

does that make more sense... it's a little harder than that dave! but, you did solve what i said!

[DonkeyOte]

Not that I'm a fan of OFFSET given it's volatility but here it might be quite useful:

=SUM(OFFSET($O$3,12*($N$2-2008),0,$M$2,1))

[robert_shindorf]

hmmm... that didn't seem to work... i'm not too familiar with the offset function either, i copied and pasted it, directly into cell O2.

[DonkeyOte]

change the 12* to 13*

Post a sample of your file if the above does not resolve the issue.