How to use the month function on a Sumifs formula?

Victoria Scholly

I have two sheets. Sheet 1 house all hours for all channels. Sheet 2 I need to pull in those hours and calculate them based on two criteria's (channel and the current month). So say one channel is Amazon. I want sheet 2 to calculate the total hours assigned to anything marked as "Amazon" but only in the current month. I figured out the formula for calculating anything marked as AMZ, I just cannot figure out how to incorporate the current month.

Paul Newcome

Try something like this...

=COUNTIFS({Channel}, "AMZ", {Date Column}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))

Victoria Scholly

So the COUNTIFS won't work as that will not calculate the total hours, just the how many cells have something inputted in the hours column. My current formula right now is: =SUMIFS({(Template) Channel Monthly Plan Range 1}, {(Template) Channel Monthly Plan Range 1}, >0, {(Template) Channel Monthly Plan Range 2}, "AMZ"). So this formula is working. I just need a way to add one more criteria and that is if the due date is within the current month.

Paul Newcome

My apologies. There have been a lot of COUNTIFS lately.

=SUMIFS({Hours}, {Channel}, "AMZ", {Date Column}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))