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
Click to expand...


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
 
Back
Top