copying formulas and stuff

  • Thread starter Thread starter theE
  • Start date Start date
T

theE

Hi, say you have a list, and you want to calculate the totals of the list,
how would you do that without a data table, and without having to change the
formula for each cell...
 
Not totally clear what you want, could you post and example?

Possilbe ideas is to write a formula in on cell and copy it over. Excel
adjust formula references based on movement.
E.g.,
=A1
copied to the right becomes
=B1
then, copied down becomes
=B2
 
Please tell us what the data looks like
Do you want to count or sum something?
best wishes
 
If your List was in Column A

at the bottom of that list

=sum(A1:A30)
Would give you the total of the list between A1 AND A30

Best

Stew
 
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

Reference Formula Help 1
Copy paste data from a column to a row 0
Hide Formula & Allow Copy 1
Formula text in woorksheet cell 2
Copy and Paste in Excel, copies cell and formula, but shows same v 3
Excel Help to copy information from one row at a time to another sheet 1
Excel Vlookup Help 0
copy formulas over merged cells 2

Back
Top