Under normal circumstances you'd probably use another function, like
Sumproduct().

You could still use SumIf() in some scenarios, like:

=Sumif(A1:A100,"=50",B1:B100)-Sumif(A1:A100,"75",B1:B100)
To get totals on Column B where Column A values are between 50 and 75.

OR

Total Column B where Column A values are equal to 50 *or* 75:

=Sum(Sumif(A1:A100,{50,75},B1:B100))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BOONER" wrote in message
...
I know this is probably elementary, but how do you do a sumif if you have
multiple criteria that needs to be met?