# COUNTIFS function with multiple criteria

✭✭✭

I have what I think should be a simple formula, but I only get "#UNPARSEABLE".

I just want to return a count when the WAVE column contains "Wave 2" AND the STATUS column contains "Not Started". My current formula is:

=COUNTIFS({Wave}, "Wave2" AND {Status}, "Not Started")

## Best Answer

• Answer ✓

Try

=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")

The `COUNTIFS` function allows you to specify multiple pairs of ranges and criteria. Each pair represents one condition. The function counts only those cells where all specified conditions are met simultaneously.

if you still get errors it could be how you have {Wave} and {Status} defined

=COUNTIFS([Wave]:[Wave], "Wave2", [Status]:[Status], "Not Started")

## Answers

• Answer ✓

Try

=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")

The `COUNTIFS` function allows you to specify multiple pairs of ranges and criteria. Each pair represents one condition. The function counts only those cells where all specified conditions are met simultaneously.

if you still get errors it could be how you have {Wave} and {Status} defined

=COUNTIFS([Wave]:[Wave], "Wave2", [Status]:[Status], "Not Started")

• ✭✭✭

Thank you - changing to the following fixed it

=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!