Sum
 

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.

Sum
 

SUM
--
Brevity is the soul of wit.


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

Sum
 

Hi

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

--
Regards

Roger Govier


"Hong" wrote in message
...
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.

Sum
 

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

--
Don Guillett
SalesAid Software

"Hong" wrote in message
...
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.

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.

Sum
 

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

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