I am new to excel and to multiply three colums together then add them
together for a final answer in a box

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

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"
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" wrote in message
...
"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 ..
.. 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 ,
ntobias wrote:

I am new to excel and to multiply three colums together then add them
together for a final answer in a box

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


with @tiscali.co.uk


"JE McGimpsey" wrote in message
...
One way:

=SUMPRODUCT(A1:A100,B1:B100,C1:C100)

Note that all the column lengths must be the same.

In article ,
ntobias 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" wrote in message
...
"JE McGimpsey" wrote in message
...
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


with @tiscali.co.uk


"JE McGimpsey" wrote in message
...
One way:

=SUMPRODUCT(A1:A100,B1:B100,C1:C100)

Note that all the column lengths must be the same.

In article ,
ntobias wrote:

I am new to excel and to multiply three colums together then add them
together for a final answer in a box