Thread: Sum
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Myriam Myriam is offline
external usenet poster
 
Posts: 97
Default Sum

If the figures you need added are on the same rows in each column you just
need to =sum(A10,A20,A30..etc) and then copy this formula to the other
columns you need totaled.
If you have subtotals in different rows, you can use SUMIF or use the
SUBTOTAL function.
Regards,


"Hong" wrote:

I have a spreadsheet with a lot of data already, I need to sum the total from
diferent column, for example sum(A10+A20+A30+A40+A50......), what kind of
function I should use? Any help is appreciate.