SUMIFS with Text and Date criteria

Hello All,

I am new to the forum and need some expert help.

All i want is to get a figure total based on 2 criteria.
A1 - Dates
B1 - Amounts
C1 - Authorized by

D1 = Total amounts Authorized by Simon in May 2018)

I have tried the following but no result

=SUMIFS(B:B,C:C,"simon",B:B,">="&DATE(2018,5,1),B:B,"("<="&EOMONTH(DATE(2019,5,1)")
=SUM(SUMIFS(B:B,C:C,{"May18"},C:C,{"simon"})) This works but the day in the date as to be 01.

Any Advice?

Thanks
Ela

Originally Posted by Pepe Le Mokko

Use a Pivot Table

I actually want the result to be part of another report (different sheet in the same workbook) so the pivot table does not really help me.

Please do correct me if i am wrong.

Try

=SUMIFS(B:B,C:C,"simon",A:A,">="&DATE(2018,5,1),A:A,"<="&EOMONTH(DATE(2018,5,1),0))

Or

in E1

=SUMIFS(B:B,C:C,"simon",A:A,">="&D1,A:A,"<="&EOMONTH(D1,0))

where D1=01/05/2018