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 |