Thread: I am new to excel and to multiply three colums together then add
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default I am new to excel and to multiply three colums together then a
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
---
Reply With QuoteReply With Quote