copying formulas and stuff

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

Luke M

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
 
B

Bernard Liengme

Please tell us what the data looks like
Do you want to count or sum something?
best wishes
 
S

stew

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
 
Top