The COUNTA(D1:D100) function will count all non-blank cells in the range
D1:D100. The COUNTIF(D1:D100,"bla") will count how many times the text
"bla" occurs in the range D1:D100.

That should work for you unless I missed something.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=379763