I am new to excel and to multiply three colums together then add

[ntobias]

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

 

[Max]

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

 

[Epinn]

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" <[email protected]>
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

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]

.. to multiply three colums together then add them together ..

Do this first:

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)
E1 should return the results you want

(Trying to keep things simple here since you are a newuser)

 

[JE McGimpsey]

One way:

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

Note that all the column lengths must be the same.

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Epinn]

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