Princess V Wrote:
This was of great help. So lets say I want to obtain a count of the
reverse.
That is everything except for the big green apples?
[...]



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


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