Need help with some type of sum formula

[Jiimmyd92]

Hi All,

New to the forum and hoping that you all can help. Started working on something yesterday that I thought would be simple but has proven tricky. I need to sum the YTD total for a given line in an excel sheet. I am able to reference the condition and month number, but would need it to sum that month and previous months. Any help would be appreciated.

I am trying to write a formula that would allow me to reference condition 2 and sum YTD through month 3, which would give me a total of 150. Is this possible? I already tried a sumif and got a value error...

Thanks

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]Condition 1[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Condition 2[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Condition 3[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Condition 4[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

 

[63falcondude]

Try something like this

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M
1		1	2	3	4	5	6	7	8	9	10	11	12
2	Condition 1	10	10	10	10	10	10	10	10	10	10	10	10
3	Condition 2	50	50	50	10	10	10	10	10	10	10	10	10
4	Condition 3	10	10	10	10	10	10	10	10	10	10	10	10
5	Condition 4	10	10	10	10	10	10	10	10	10	10	10	10
6
7
8	Condition	2
9	Through Month	3
10	Sum	150
Sheet1

Cell Formulas
Range	Formula
B10	=SUMPRODUCT((A2:A5="Condition "&B8)*(B1:M1<=B9)*(B2:M5))

 

[Jiimmyd92]

That did it. Thank you so much!

 

[63falcondude]

You're welcome.