Hi - Newbie here, but how do you count several text values in the same column?
=COUNTIF(Status:Status, "Closed" OR "Deployed")
doesn't work
=COUNTIF(Status1:Status9, "Closed") + COUNTIF(Status1:Status9, "Deployed")
This will add any rows with "Closed" or "Deployed"
Make sure you adjust your range to the correct rows.
ah. great.
easy when you know how!
