I have a sheet that has a status column which is a dropdown list - In progress, not started and complete.
I want to return the number of rows where status is not complete.
How do I do this?
=countifs([Status]1:[Status}100,<>"Complete") Should do it. Where 1:100 is the range. "<>" is "not equal".
