Pls stay in the ORIGINAL thread for continuity.

$A$2:$A$4 or Name it
--
Don Guillett
SalesAid Software

"Sean" wrote in message
...
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