Assuming the source letters are in col A,
maybe something like this in say, B1: =COUNTIF(A:A,"V")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"spring022377" wrote:
I am trying to figure out sales from an existing spreadsheet. The
spreadsheet containes packages (A-V) sold. Each cell may contain more than
one of each letter so I can't just use the CountA function because that only
counts the cell. I need something to actually count the letters to tell me
how many times it occurs in the range. Is this at all possible? It seems
like it would be and that it should be simple, but I am stuck. Please help!
Thanks.