R
RollieG
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'!$AS$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:$AS$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.
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'!$AS$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:$AS$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.