copying formulas and stuff
 

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

copying formulas and stuff
 

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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"theE" wrote:

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

copying formulas and stuff
 

Please tell us what the data looks like
Do you want to count or sum something?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"theE" wrote in message
...
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...

copying formulas and stuff
 

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


"theE" wrote:

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