Formula Copy
 

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

Formula Copy
 

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?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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

Formula Copy
 

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

Formula Copy
 

"Sean" ha scritto nel messaggio


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


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
--
Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------