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