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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to excel and to multiply three colums together then add them
together for a final answer in a box
 
ntobias said:
I am new to excel and to multiply three colums together then add them
together for a final answer in a box
Click to expand...

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
Click to expand...
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 ..
Click to expand...
[assume you mean the same three colums]

Place in say, E1: =SUM(A1:C1)
Copy E1 down

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

Max said:
ntobias said:
I am new to excel and to multiply three colums together then add them
together for a final answer in a box
Click to expand...

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
Click to expand...
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 ..
Click to expand...
[assume you mean the same three colums]

Place in say, E1: =SUM(A1:C1)
Copy E1 down

---
Click to expand...
 
.. to multiply three colums together then add them together ..
Click to expand...

Do this first:
Assume data in cols A to C, from row1 down
Then place in say, D1: =A1*B1*C1
Copy D1 down
Click to expand...

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)

---
 
One way:

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

Note that all the column lengths must be the same.
 
JE McGimpsey said:
One way:

=SUMPRODUCT(A1:A100,B1:B100,C1:C100)
Click to expand...

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
 
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
 
Back
Top