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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200603/1

=COUNTIF(A1:A100,"<H")

"brian thompson3001 via OfficeKB.com" <u15682@uwe wrote in message
news:5cf44b63f3687@uwe...
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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200603/1

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

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

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

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
---

thanks to you all

I used Max in the end

regards

Max wrote:
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
---

--
bnt

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

You're welcome (from us) !
Thanks for posting back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"brian thompson3001 via OfficeKB.com" <u15682@uwe wrote in message
news:5d0a521076b0c@uwe...
thanks to you all

I used Max in the end