Copy and Paste

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hi,
I have a lot of grouped formulas. I want
to reuse some with copy and paste. But when
I try to paste excel changes the number of
cells in the formula.
Like SUMPRODUCT(--(Admin!F1:F10000=1),--(Admin!
H1:H10000=8)) to


=SUMPRODUCT(--(Admin!F5:F10004=1),--(Admin!H5:H10004=8))


I went in the PASTE SPECIAL
but nothing to paste the same cells values....!!!!


THanks if you have an idea...

Jack
 
Hi
look at the help for relative versus absolute references. for your
example use
SUMPRODUCT(--(Admin!$F$1:$F$10000=1),--(Admin!$H$1:$H$10000=8))
 
Jack,

The cells that you want to remain constant must be entered as absolute
values i.e. $F$1: $F$10000. (The $ sign in front of F locks down the
column; $sign in front of just the 1 locks down the row)
You can do this by placing the cusor within the address and pressing
the F4 function key
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Copy and Pasting Formulas are incrementing 3
pasting content copied from nonadajacent cells 1
Scrabble Value calculation for Welsh words 0
Excel copy and paste 1
HELLO and HELP 5
Column : transfer from sheet1 to sheet2 1
I can't copy and paste equations 0

Back
Top