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)*(S heet1!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