Conditional Range sum formula

Hi,

I am trying to create a conditional sum.

My data is as the example bellow (but with a much large data, 350.000 lines)


aa.JPG



A B C

1 Year Month Value
2 2014 03 5
3 2014 02 5
4 2014 01 3
5 2013 12 4
6 2013 11 8
7 2013 01 2
8 2012 10 5
9 2012 09 7
10 2011 12 6
11 2011 01 4



What I need is to add the values for the dates in the range of 2012/10 and 2014/02 (including those months), so the total would be 27.

I’ve tried sumif and sum(if()), but couldn’t do it, hope someone could help me.

My data have more columns as well, but with much easier criteria to filter (sumifs solves it easially), my problem is filtering this conditioning with the conditional range.

Hi and welcome to the forum

(sumifs solves it easially), my problem is filtering this conditioning with the conditional range.

what do you meant by filtering on a conditional range?

Also, dates are almosr always easier to work with if you use actual dates, instead of the year in 1 cell, the month in another etc. I would combine those "dates" to become real dates...=DATE(A2,B2,1)

	A	B	C	D	E
1	Year	Month	Value
2	2014	3	5	3/1/2014	27
3	2014	2	5	2/1/2014
4	2014	1	3	1/1/2014
5	2013	12	4	12/1/2013
6	2013	11	8	11/1/2013
7	2013	1	2	1/1/2013
8	2012	10	5	10/1/2012
9	2012	9	7	9/1/2012
10	2011	12	6	12/1/2011
11	2011	1	4	1/1/2011

E2=SUMIFS($C$2:$C$11,$D$2:$D$11,">="&DATE(2012,10,1),$D$2:$D$11,"<="&DATE(2014,2,1))