Thread: Formula Copy
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Franz Franz is offline
external usenet poster
  
Posts: 10
Default 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)
----------------------------------------------------------------------------------------


Reply With QuoteReply With Quote