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

	1	2	3	4	5	6	7	8	9	10	11	12
Condition 1	10	10	10	10	10	10	10	10	10	10	10	10
Condition 2	50	50	50	10	10	10	10	10	10	10	10	10
Condition 3	10	10	10	10	10	10	10	10	10	10	10	10
Condition 4	10	10	10	10	10	10	10	10	10	10	10	10

<tbody>
</tbody>

 

[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.