Princess V Wrote:
Sorry,

Let me elaborate some more.

In a spreadsheet of my own (a lot bigger then the one I have shown
below) I
have to count everything except for certain things. Is there a symbol
that
means "does not equal to?" I know that greater than is and less then
is <
etc....what is does not equal?

So for example, I want to count everything except apples and blanks...
[...]

< means not equal.

Did you try the one I posted?

Perhaps this is better:

=SUMPRODUCT(--($A$2:$A$10&$B$2:$B$10&$C$2:$C$10<""),--($A$2:$A$10&","&$B$2:$B$10&","&$C$2:$C$10<"Apple, Green,Big"))

should to count all non-blank records that do not consist of Apple,
Green, and Big at the same time.


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274322