Found it, thanks.

MrYogi

Platinum Member
Mar 15, 2003
2,680
0
0
Excel file has column of one of a, b, c, ord d.
I need to find out how many times 'a' occured and 'b', and 'c' and 'd'.

is there a formula for doing this? No, this is not my homework. I am past that age. :)

Thanks. :)

=COUNTIF($A$1:$A$600,"a")