|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I am new to excel and to multiply three colums together then add them
together for a final answer in a box
|
|
"ntobias" wrote:
[Quoted Text] > I am new to excel and to multiply three colums together then add them
> together for a final answer in a box
As-is above, I'm not really sure what you want to do <g>
Let's try to break things down .. if we want:
> .. to multiply three colums together
Assume data in cols A to C, from row1 down
Then place in say, D1: =A1*B1*C1
Copy D1 down
> .. to add them together ..
[assume you mean the same three colums]
Place in say, E1: =SUM(A1:C1)
Copy E1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
|
|
Hi Ntobias,
Using Max's example, I assume you want to add column D up, right?
It will be a good idea to use Offset() when you try to add up the cells.
For details, please refer to the following thread on Aug. 21.
********************************************************
From: "ljsbjs" <ljsbjs[ at ]discussions.microsoft.com>
Subject: What is the Excel formula for adding 1 column with several rows?
Date: Monday, August 21, 2006 9:50 PM
********************************************************
Good info here http://www.mvps.org/dmcritchie/excel/offset.htm
Epinn
"Max" <demechanik[ at ]yahoo.com> wrote in message
news:4FA89A4A-840B-4652-892A-CE0BC174AB70[ at ]microsoft.com...
[Quoted Text] > "ntobias" wrote: > > I am new to excel and to multiply three colums together then add them > > together for a final answer in a box > > As-is above, I'm not really sure what you want to do <g> > > Let's try to break things down .. if we want: > > > .. to multiply three colums together > Assume data in cols A to C, from row1 down > Then place in say, D1: =A1*B1*C1 > Copy D1 down > > > .. to add them together .. > [assume you mean the same three colums] > > Place in say, E1: =SUM(A1:C1) > Copy E1 down > -- > Max > Singapore > http://savefile.com/projects/236895> xdemechanik > ---
|
|
Ok <g>, after a breath of fresh air, revisiting your original post ..
[Quoted Text] > .. to multiply three colums together then add them together ..
Do this first:
> > .. to multiply three colums together
> Assume data in cols A to C, from row1 down
> Then place in say, D1: =A1*B1*C1
> Copy D1 down
Then we could just place in say, E1: =SUM(D:D)
E1 should return the results you want
(Trying to keep things simple here since you are a newuser)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
|
|
One way:
=SUMPRODUCT(A1:A100,B1:B100,C1:C100)
Note that all the column lengths must be the same.
In article <4089B320-33E9-4C77-86E8-286B46338B4A[ at ]microsoft.com>,
ntobias <ntobias[ at ]discussions.microsoft.com> wrote:
[Quoted Text] > I am new to excel and to multiply three colums together then add them
> together for a final answer in a box
|
|
"JE McGimpsey" <jemcgimpsey[ at ]mvps.org> wrote in message
news:jemcgimpsey-CD81E8.23362124082006[ at ]msnews.microsoft.com...
[Quoted Text] > One way:
>
> =SUMPRODUCT(A1:A100,B1:B100,C1:C100)
What? And use SUMPRODUCT() the way that Microsoft intended it to be used?
How unusual! <g>
--
Sandy
In Perth, the ancient capital of Scotland
sandymann2[ at ]mailinator.com
Replace[ at ]mailinator.com with [ at ]tiscali.co.uk
"JE McGimpsey" <jemcgimpsey[ at ]mvps.org> wrote in message
news:jemcgimpsey-CD81E8.23362124082006[ at ]msnews.microsoft.com...
> One way:
>
> =SUMPRODUCT(A1:A100,B1:B100,C1:C100)
>
> Note that all the column lengths must be the same.
>
> In article <4089B320-33E9-4C77-86E8-286B46338B4A[ at ]microsoft.com>,
> ntobias <ntobias[ at ]discussions.microsoft.com> wrote:
>
>> I am new to excel and to multiply three colums together then add them
>> together for a final answer in a box
|
|
Sandy,
I just want to let you know that your comment means a lot to me. You seem
to have spelt out something for me. I have started a new thread on
SUMPRODUCT.
Epinn
"Sandy Mann" <sandymann2[ at ]mailinator.com> wrote in message
news:eqpmoUEyGHA.3440[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text] > "JE McGimpsey" <jemcgimpsey[ at ]mvps.org> wrote in message
> news:jemcgimpsey-CD81E8.23362124082006[ at ]msnews.microsoft.com...
> > One way:
> >
> > =SUMPRODUCT(A1:A100,B1:B100,C1:C100)
>
> What? And use SUMPRODUCT() the way that Microsoft intended it to be used?
> How unusual! <g>
>
> --
>
> Sandy
> In Perth, the ancient capital of Scotland
>
> sandymann2[ at ]mailinator.com
> Replace[ at ]mailinator.com with [ at ]tiscali.co.uk
>
>
> "JE McGimpsey" <jemcgimpsey[ at ]mvps.org> wrote in message
> news:jemcgimpsey-CD81E8.23362124082006[ at ]msnews.microsoft.com...
> > One way:
> >
> > =SUMPRODUCT(A1:A100,B1:B100,C1:C100)
> >
> > Note that all the column lengths must be the same.
> >
> > In article <4089B320-33E9-4C77-86E8-286B46338B4A[ at ]microsoft.com>,
> > ntobias <ntobias[ at ]discussions.microsoft.com> wrote:
> >
> >> I am new to excel and to multiply three colums together then add them
> >> together for a final answer in a box
>
>
>
|
|
|