- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- cell formula for counting instances of text?

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

- RE: cell formula for counting instances of text? posted by Elkar on Tue, 23 May 2006
- RE: cell formula for counting instances of text? posted by CLR on Tue, 23 May 2006
- RE: cell formula for counting instances of text? posted by Kevin B on Tue, 23 May 2006