I have a 'Detail' worksheet that I am trying to summarize on the 'Recap' worksheet based on Date and Category.
-It's a large worksheet that is continually added to so i would like it to update as I enter new information
-I would like to use the month() formula as one of the criteria as opposed to a ">=" & "<=" date criterias
-With a SUMIF I can get the working Total without a date criteria, but my SUMIFS does not return the correct amount
=SUMIF('Detail'!$E:$E,"A",Detail'!$D:$D)
=SUMIFS('Detail'!D:D,'Detail'!E:E,"A",'Detail'!A:A,"month(1)")
I have attached a sample sheet to show what it is I'm looking for. Thanks so much in advance!
Bookmarks