Looks like you need some wildcards in the
=SUMIF($B$2:$B$13,"<*m*",$A$2:$A$13)

"Father" wrote:

Still no go :)

=SUMIF($B$2:$B$13,"<m",$A$2:$A$13) will exclude "m" but will include "m, n"
I need it to exclude both (as well as other combinations with 'm' in them)
"Hanzo" wrote:


You are right! Sorry! I misread it...
Well, in that case the code you need is

=SUMIF($B$2:$B$13,"<m",$A$2:$A$13)

The < symbol means "DIFFERENT FROM".
What it does is SUM everything that is not m.

I guess that's what you really need?
Sorry for the inconvinience!


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