As I stated in your other post that people still read, you cannot do what you
are wanting to do. There is a 'way' that SUMIF can take multiple criteria,
but it still won't work for your purposes.
Check Dave's response to this post:
http://www.microsoft.com/office/comm...7-197b6dc1d381
It shows you can have 2 values within the sumif, but it changes the formula
to have an additional SUM around your SUMIF formula.

Why are you adverse to changing the formula if it not ONLY achieves the
desired result but is also easier to modify in the future?
--
** John C **

"RollieG" wrote:

I originally asked:

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.

To which I got this answer:

Just add them:

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

This will not solve my dilemna. I replied to that with this, but i'm afraid
the post will not be read. So I am re-asking the question.


Thank you, but this is what I want to do:

Here is the actual formula that I need to change:

=IF(ISBLANK('29'!$AS$2:$AS$5000),"",SUMIF('29'!$AS $2:$AS$5000,$C$2,'29'!$AT$2:$AT$5000)).

I want to use the Find and Replace function to replace the criteria "$C$2"
with the desired expression ($C$2 or $K$1).

I didn't originally design this worksheet, and I am stuck with the original
logic. There are actually over 150 tabs with 31 formulas on each sheet to
change. I wanted to use the Repace all function, selecting multiple sheets
(tabs), so I can change all the formulas at one time.

Changing it with your suggestion would mean, if I am understanding you
correctly, would change the formula to :

=IF(ISBLANK('29'!$AS$2:$AS$5000),"",SUMIF('29'!$AS $2:$AS$5000,$C$2,'29'!$AT$2:$AT$5000+SUMIF('29'!$A S$2:$AS$5000,$K$1,'29'!$AT$2:$AT$5000))

The Sheet tab '29" refers to a sheet with data from the 29th of the month.
The next formula on the next row is:

=IF(ISBLANK('30"AS$2:$AS$5000),"",SUMIF('30'S$2:$A S$5000,$C$2,'29'!$AT$2:$AT$5000)). So, I cannot fill down formulas.

This is why I would like to change the formula using the Find and Replace
method.

I thought there could be an expression in the criteria part of the formula
that can refer to one of two or more values.