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

thanks

--
Message posted via http://www.officekb.com