View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Art is offline
external usenet poster
 
Posts: 587
Default Sum and multiply

Hello:

I have in row A for E.G. amounts, lets say:
A 3 6 4
B 2.00 3.00 2.50

Is there an easier way to calculate all together. The long way is
=(A1*B1)+(A2*B2)..., is there a shorter way to write this calculation?