I need to sum data based on 3+ criteria one being the month.  

"Usage" tab contains entries for`A=Date C=department, D=fuel E=Gallons`

Im trying to generate a monthly report where the following is true  

`fuel=diesel`, `dept=public works`, `month=B2` (B2 is a month by number drop list, problem still exist if I substitute 1, 2, 3, etc.)

I can get the below formula to work until I add the date field, either I get `#NAME?`, or an error regarding my formula. Any suggestions would be appreciated.

`=SUM(IFS(Usage!$E:$E,(Usage!$D:$D),"Diesel",(Usage!$C:$C),"Public Works",MONTH(Usage!A:A),B2))`

Thanks  

Vona