# How to use the month function on a Sumifs formula?

Options

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.

• ✭✭✭✭✭✭
Options

Try something like this...

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

• edited 02/11/21
Options

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.

• ✭✭✭✭✭✭
Options

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

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!