Sum

[Hong]

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.

 

[Dave F]

SUM

 

[Roger Govier]

Hi

One way
=SUMPRODUCT((MOD(ROW(A1:A100),10)=0)*(A1:A100))
Change ranges to suit.

 

[Don Guillett]

=SUMPRODUCT(--(MOD(ROW(a1:a21)-ROW(a1),10)=0),a1:a21)

 

[Myriam]

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,

 

[driller]

hi Hong,

i am confused again,,sorry,

if this is the total of your column A(colA) =sum(A10+A20+A30+A40+A50......)
then, you want to sum the total from different Column...
then maybe

=sum("your total of column A","your total of column B",,,whereever)

or
="your total of column A" + "your total of column B" + wherever is the column

or if it is contiguous
=sum("ref. colA":"ref. colX")

happy hoplidays