SUMIFS + CONTAINS Formula help.

Options

Hi there!


I am trying to figure out how many projects start in the current month for a designated department.


This formula works: =COUNTIFS(Department:Department, "Marketing", Start:Start, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))


However, I tried to apply it to a new sheet where the department is a multiple drop down and more than one department can be selected per project. It's only picking up the cells that JUST have the "Marketing" department.


I tried to use CONTAINS and came up with this, but its not working:

=COUNTIFS(Department:Department, "Marketing", (CONTAINS("Marketing")) Start:Start, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))


Any suggestions?


Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!