As a followup, since we don't know how the values in $C$1 and $D$1 are
generated, is there ever a chance they will be equal to each other? If so,
you could modify Gary's suggestion like so:
=(SUMIF(...)+SUMIF(...))/(1+($C$1=$D$1))
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Gary''s Student" wrote:

Just add them:

=SUMIF() + SUMIF()
--
Gary''s Student - gsnu200810


"RollieG" wrote:

How do you use SUMIF, when your criteria is one of two(or multiple) values?

For Example, I want to use:

=SUMIF(A2:A10, ($C$1 or $D$1), B2:B10), but I know ($C$1 or $D$1) is not the
correct syntax.