Try: =SUMPRODUCT((A1:A100<"H")*(A1:A100<""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"brian thompson3001 via OfficeKB.com" <u15682@uwe wrote in message
news:5cf4942f9c7ce@uwe...
only thing is it counts the blank cell, and i want to count only if
populated
other than "H"

regards

Bob Umlas wrote:
=COUNTIF(A1:A100,"<H")

hi

how do i enter to count if not the letter "H" in a range. All will be
letters in the cells