only thing is it counts the blank cell, and i want to count only if
populated other than "H"

Try: =SUMPRODUCT((A1:A100<"H")*(A1:A100<""))

The earlier suggestion assumes case sensitivity is not an issue.
If it is, try:
=SUMPRODUCT((NOT(ISNUMBER(FIND("H",A1:A100)))*(A1: A100<"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---