MrExcel Consulting
Your One Stop for Excel Tips & Solutions

not equal to


Posted by Latigo on December 05, 2001 1:32 PM

What is the correct way to enter "not equal to" in a criteria for a sum if

For example: countif( not equal to 0)

Posted by Katt on December 05, 2001 1:34 PM

You will want to use <> for not equal to.
KS

Posted by IML on December 05, 2001 2:15 PM

=COUNTIF(A1:A6,""&0) (no text)

Posted by IML on December 05, 2001 2:16 PM

Re: =COUNTIF(A1:A6," "&0) (without the spaces) (nt)

Posted by IML on December 05, 2001 2:18 PM

Last try

Surround the the assume A is the less sign, and B is the greater sign:

the formula would be
=COUNTIF(A1:A6,"ab"&0)

If you just put
=COUNTIF(A1:A6,ab0)

it looks to count text items that are equal to the string
"AB0"

Just when I thought I new how to get greater and less than signs post, it turns out I don't.