COUNTIFS for 2 and 3 criterion

daniel68616

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))

Andrée Starå

Hi Daniel,

Try removing the last parenthesis, so it ends with =1)

Did it work?

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting