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

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

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