Try...

=COUNTIF(A2:A100,"?*")-COUNTIF(A2:A100,"H")

Hope this helps!

In article <5cf44b63f3687@uwe,
"brian thompson3001 via OfficeKB.com" <u15682@uwe wrote:

hi

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

thanks