How can I count more than one status in a column

Jeannie Peirce

=COUNTIFs(([BTA Deployment Status]:[BTA Deployment Status], ="On Hold")([BTA Deployment Status]:[BTA Deployment Status], ="Credentials Needed"))

Where there are more than one status... "On Hold", "Credentials Needed", and "Complete"... but I only want to count the ones that are not complete

Scott Peters

Hello Jeannie - Have you tried a helper column using an or statement? Something like COUNTIFS(OR([BTA Deployment Status]@row = "On Hold", [BTA Deployment Status]@row = "Credentials Needed", etc.)). From there, you could report, filter, etc. on rows where that helper column is

Hope this idea helps,

Scott

Paul Newcome

You have two options.

You can either exclude "Complete" like so:

=COUNTIFS([BTA Deployment Status]:[BTA Deployment Status], @cell <> "Complete")

Or you can use an OR function to include both choices like so:

=COUNTIFS([BTA Deployment Status]:[BTA Deployment Status], OR(@cell = "On Hold", @cell = "Credentials Needed"))

Jeannie Peirce

Thank you both! I'll play around with both options. Much appreciated!

Paul Newcome

Happy to help. 👍️