View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default 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...