View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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.