Result sum depending upon fiscal period

[David In OC California]

Formula in Column P need to add data in Columns Q:AB depending upon fiscal month. Jan data in ColQ, Feb data in ColR, etc. Cell E1 has the fiscal month, ie E1=2, which corresponds to Feb.
If E2 = 1 (Jan), then Col P should only sum data in ColQ. If E2=2 (Feb) then Col P should sum data in ColQ+R. If E2 = 3(Mar) then ColP should sum ColQ + R + S.

 

[jtakw]

Hi,

Are there Headers in Q:AB indicating the Date/Month, if so, is it Text, Date values?

 

[David In OC California]

values 1 thru 12 depending upon month. 1=Jan, 2=Feb, etc.

 

[jtakw]

So the Headers are numbers?

 

[David In OC California]

yes. But I can change that to Jan, Feb, Mar if needed.

 

[jtakw]

No, that's fine, just needed to know:

Book3.xlsx
	E											P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	3											330	1	2	3	4	5	6	7	8	9	10	11	12
2													100	110	120	130	140	150	160	170	180	190	200	210
Sheet1046

Cell Formulas
Range	Formula
P1	P1	=SUMIF(Q1:AB1,"<="&E1,Q2:AB2)

 

[David In OC California]

ok, perfect... thank you!

 

[jtakw]

You're welcome, thanks for the feedback.