Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"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 --- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
i want my excel colums to be rows | Excel Worksheet Functions | |||
How do I name my colums in Excel ? | New Users to Excel |