cell formula for counting instances of text?

Giganews Newsgroups
Subject: cell formula for counting instances of text?
Posted by:  Samuel (stwils…@writeme.com)
Date: 23 May 2006

I have a cell that could have PASS, FAIL, or N/A
What kind of formula can I use to count the number of times PASS FAIL
or N/A occurs in the column and write the count to a header cell?
I can do math to sum, avg, etc, but I am not sure how to deal with
text.
Thank you,
Sam

Replies