=SUMIF QUESTION

  • Thread starter Thread starter REGGIE
  • Start date Start date
R

REGGIE

=SUMIF(Sheet1!$A$8:$A$39,25260,Sheet1!$M$8:$M$39)+SUMIF
(Sheet1!$A$50:$A$82,25260,Sheet1!$M$50:$M$82)+SUMIF(Sheet1!
$A$95:$A$127,18129,Sheet1!$M$95:$M$127)

IS THERE A WAY TO CHANGE THE CRITERIA OF ALL THREE PARTS
OF THIS EQUATION IN ONE ACTION. I WILL BE USING THIS A
LOT, AND THE CRITERIA WILL CHANGE FREQUENTLY...ALL THREE
PARTS SHOULD HAVE THE SAME CRITERIA
 
Reggie

switch off your caps lock ... it is considered rude to SHOUT in News Groups.

You could put the value/criteria into a known/fixed cell and refer to that
rather than the actual value.

=SUMIF(Sheet1!$A$8:$A$39, $AA$1, Sheet1!$M$8:$M$39)
+SUMIF(Sheet1!$A$50:$A$82, $AA$1, Sheet1!$M$50:$M$82)
+SUMIF(Sheet1!$A$95:$A$127, $AA$1, Sheet1!$M$95:$M$127)

In this case, use cell $AA$1 to hold the value (25260 (or is it 18129 ?))

Regards

Trevor
 
I'm sorry for the ignorance to the post...thank you for
your suggestion..i think that will work
 
Back
Top