Countif NOT

  • Thread starter brian thompson3001 via OfficeKB.com
  • Start date
B

brian thompson3001 via OfficeKB.com

hi

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

thanks
 
B

brian thompson3001 via OfficeKB.com

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

regards
 
M

Max

only thing is it counts the blank cell, and i want to count only if
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<>"")))
 
B

brian thompson3001 via OfficeKB.com

thanks to you all

I used Max in the end

regards
The earlier suggestion assumes case sensitivity is not an issue.
If it is, try:
=SUMPRODUCT((NOT(ISNUMBER(FIND("H",A1:A100)))*(A1:A100<>"")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top