Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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".
