| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i make excel do this a*b=c then add the c colum up
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i make excel do this a*b=c then add the c colum up
in clumn A, put the first value, in B put the b value, and in column C
put =a1*b1. At the end of the C column put =sum(c1:c20) or the appropriate row # for start and end rows. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=SUMPRODUCT(A1:A5,B1:B5)
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, when column A and B have same name make column C add up in mail merge | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel formula to make AAA-BBB equal to/consistent with BBB-AAA | Excel Worksheet Functions | |||
| How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
| Make copy from any document into Excel a right click with a drop . | Excel Worksheet Functions | |||
Linear Mode
