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
Tags:
Best Answer

I would start by double checking that BOTH ranges are entire columns.
If that is not the issue, can you copy/paste the formula directly from the sheet to here?
Answers

Your formula looks correct. Are both your ranges the entire column?
If not, I'd give that a shot.

Yes, my range is the entire column.

I would start by double checking that BOTH ranges are entire columns.
If that is not the issue, can you copy/paste the formula directly from the sheet to here?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!