=SUMIF QUESTION

[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

 

[Trevor Shuttleworth]

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

 

[Reggie]

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