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