Formula Copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok, everyone has been great so far. Here is my next question?

Here is my current formula:

=SUMPRODUCT((Sheet1!A2:A4=3)*(Sheet1!B2:B4=100)*(Sheet1!C2:C4={"C","P","S","T"})*Sheet1!E2:E4)

Now I want everything to stay the when I copy it in to other cells, however
we all know what happens Excel changes your ranges or columns depending on
how you copy it. Help!!!???

Thanks Sean
 
Hi Sean

does
=SUMPRODUCT((Sheet1!$A$2:$A$4=3)*(Sheet1!$B$2:$B$4=100)*(Sheet1!$C$2:$C$4={"C","P","S","T"})*Sheet1!$E$2:$E$4)

give you what you want?
 
Ok, everyone has been great so far. Here is my next question?

Here is my current formula:

=SUMPRODUCT((Sheet1!A2:A4=3)*(Sheet1!B2:B4=100)*(Sheet1!C2:C4={"C","P","S","T"})*Sheet1!E2:E4)

Now I want everything to stay the when I copy it in to other cells,
however we all know what happens Excel changes your ranges or columns
depending on how you copy it. Help!!!???

Thanks Sean


You should use absolute refereces, i.e.
=SUMPRODUCT((Sheet1!$A$2:$A$4=3)*(Sheet1!$B$2:$B$4=100)*(Sheet1!$C$2:$C$4={"C","P","S","T"})*Sheet1!$E$2:$E$4).

Hoping to be helpful...

Regards
 

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

Back
Top