index match vlookup hlookup date month dilemma

[twl2009]

Hi, I am trying to find a way to search a large sheet of data and then sum the values based on two criteria.
For example I need to return the sum of colB for each Orange in colC in the month of "Jul" colA, IE 3 in this case.
The month will be expressed MMM, but colA will be as below.
Is this possible with a combo of index match and lookup?



_____A_____B___C
1 2018-08-03 3 Orange
2 2018-07-18 1 Pear
3 2018-07-09 2 Orange
4 2018-07-03 1 Orange
5 2018-06-27 1 Pear
6 2018-06-01 2 Orange

Thanks Twl

 

[Aladin Akyurek]

Like this for example...

=SUMIFS(B:B,C:C,"orange",A:A,">="&"2018-07-01",A:A,"<="&EOMONTH(

"2018-07-01",0))​

 

[twl2009]

Exactly, except col A has date fields 'yyyy-mm-dd', but the value to lookup, IE july, will be in another cell, lets say D1 and will be MMM. Is that possible?

 

[twl2009]

My mistake, it works beautifully. Thank you

 

[Aladin Akyurek]

My mistake, it works beautifully. Thank you

You are welcome.