=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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Something Missing 4
Sum If function 3
SUMIF FUNCTION 5
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
can lookup return cell reference istead of "text" for sumif? 1
SUMIF Help (Excel 2002) 1
Sumproduct with more than one valid criteria 1

Back
Top