You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I have a Numbers spreadsheet where I have a column showing if something has been "Approved", is "Pending", or was "Not Approved" -- using the words from between the quotes
How do I get a Total count of the Approved items?
If need be, I can change the text "Not Approved" to "Declined" to make the formula work. (I assume most formulas could potentially see the word "Approved" in both "Not Approved" and "Approved")
You could use the COUNTIF function. If, for instance, your data is in column A, the formula for "Approved" would be:
COUNTIF(A,"Approved")
This formula has no risk of counting rows containing "Not Approved."
You could use the COUNTIF function. If, for instance, your data is in column A, the formula for "Approved" would be:
COUNTIF(A,"Approved")
This formula has no risk of counting rows containing "Not Approved."
COUNTIF() will use a case-insensitive 'exact' match by default, so:
=COUNTIF(A,"Approved")
will match "Approved", "approved" and "ApPrOVeD", but will not match "Not Approved").
It does support wildcards, so you can
=COUNTIF(A, "*Approved*")
To match both "Approved" and "Not Approved", should you need it.
You can also do inverse matches:
=COUNTIF(A,"<>Approved")
returns all cells that are not "Approved"
Thanks 6x6 and Camelot... you both supplied the same info.
It works exactly as you said it should!
Took me a few moments to work out I had to change the A, to H, -- the column I needed counted.
If I had read 6x6's message properly the first time, I would have figured this out much quicker :)
But I'm happy and now have the answer I need (118 is the count in my spreadsheet :))
I also added & " Approved" so the cell now shows 118 Approved
Counting a Column of "Words" in Numbers
