SUM formula for different sheets

  • Thread starter Thread starter Chow
  • Start date Start date
C

Chow

How to keep the same formula value when you copy a column to different sheet?
 
Hi,

Not sure what you want - to copy the formula or to copy the value?

In any case select the formula and copy it, move to the other spreadsheet
and choose Edit, Paste Special, Values.

Now if you are trying to copy the formula we would need to know what you
want the result to be - a formula that refers to the original spreadsheet or
to an identical range in the current file.
 

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

Back
Top