COUNTIFS for 2 and 3 criterion

daniel68616
daniel68616 ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello, 

I am trying to have my formula count when the row has "Ken Mallory" for the name column and any date that equals January. This is what I have so far but it is Unparseable. Thanks for your help:)

=COUNTIFS({Master Compliance Sheet Final ver 1.0 - 12 Range 2}, "Ken Mallory", {Master Compliance Sheet Final ver 1.0 - 12 Range 4}, MONTH(@cell) = 1))

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!