Sum

H

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

Roger Govier

Hi

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

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,
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top