how do i make excel do this a*b=c then add the c colum up
|
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. |
=SUMPRODUCT(A1:A5,B1:B5)
|
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com