Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
not equal toPosted 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)
|Check out our Excel Resources
Re: not equal toPosted by Katt on December 05, 2001 1:34 PM
You will want to use <> for not equal to.
=COUNTIF(A1:A6,""&0) (no text)Posted by IML on December 05, 2001 2:15 PM
Re: =COUNTIF(A1:A6," "&0) (without the spaces) (nt)Posted by IML on December 05, 2001 2:16 PM
Last tryPosted by IML on December 05, 2001 2:18 PM
Surround the the assume A is the less sign, and B is the greater sign:
the formula would be
If you just put
it looks to count text items that are equal to the string
Just when I thought I new how to get greater and less than signs post, it turns out I don't.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.