Hey Guys,
I am trying to do a SUMIF with multiple criteria from another sheet. I want to sum all rows in a sheet in which it the category matches what I define AND the month matches the month I define. Here is what I have so far...
=SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,"MONTH(Register!$A:$A)=6")
if I remove the MONTH function and specify a specific date that works
=SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,"6/15/2015")
if I try and use a wild card, it does not
=SUMIFS(Register!$D:$D,Register!$C:$C,"Transportation",Register!$A:$A,"6/15/2015")
Thanks in advance
Bookmarks