Im trying to create a COUNTIF Formula to count Categories based on a particular status.

What I am looking to do is count the Category when it has a particular status. In the end, each category will have three different formulas one for each status. Here is my current formula.

=COUNTIFS({VDC Category}, "MEPF Coordination", {VDC Status}, "Not started")

The current error is #incorrect ARG


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!