LOL!
Ok, here is the real deal!
THere are different ways to do this, but this one is a lot simplier:

=SUMPRODUCT($A$2:$A$13,--($B$2:$B$13<"m"),--($B$2:$B$13<"m,n"))

Now, A2:A13 is your range to add. B2:B13 is the range you want to
check.
As you can see, the < is present again to indicate DIFFERENT.
You can add as many as you need, like

=SUMPRODUCT($A$2:$A$13,--($B$2:$B$13<"m"),--($B$2:$B$13<"m,n"),--($B$2:$B$13<"anything"),--($B$2:$B$13<"whatever"),--($B$2:$B$13<"etc"))

Hope this one makes it! :)


--
Hanzo
------------------------------------------------------------------------
Hanzo's Profile: http://www.excelforum.com/member.php...o&userid=29955
View this thread: http://www.excelforum.com/showthread...hreadid=496536