Adding One Additional Argument to SUMIF

[meppwc]

The formula below works correctly
=SUMIF(Consolidated!D:D,Table!A2,Consolidated!P:P)

Basically it is saying that if the value in cell A2 of the "Table" worksheet is found in column D of the "Consolidated" worksheet, then sum the values in column P of the "Consolidated" worksheet.
I would like to add one additional argument to the existing formula but I am having trouble determining the syntax. I want to sum records that meet the above criteria PLUS the record must fall in the month of April.

Column E of the "Consolidated" worksheet are dates (format: 4/26/2018 11:43:41 PM)
The additional argument is, if the month derived from column E is equal to April

 

[Marcelo Branco]

Try SUMIFS

https://support.office.com/en-us/article/SUMIFS-function-C9E748F5-7EA7-455D-9406-611CEBCE642B
M.

 

[meppwc]

Marcelo
Here is what I tried............not sure if the syntax is correct or not...........but it returned #VALUE !
=SUMIFS(Consolidated!D:D,Consolidated!E:E,"MONTH(Consolidated!E:E)=4",Table!A2,Consolidated!P:P)

 

[Marcelo Branco]

No, this doesn't work

For example, to check if a date in E:E belongs to July 2018 you need two conditions, like:
E:E,">="&DATA(2018,7,1),E:E,"<="&EOMONTH(DATE(2018,7,1),0)

M.

 

[Marcelo Branco]

oops there is a typo in the expression above.
Should be
E:E,">="&DATE(2018,7,1),E:E,"<="&EOMONTH(DATE(2018,7,1),0)

M.