View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ryan Gerry Ryan Gerry is offline
external usenet poster
 
Posts: 6
Default Sum/multiply function

Experts,

I am looking to multiply column A by column B and then sum multiple rows in
a single step.

Example:

A B
1 11 1
2 22 2
3 33 3
4 44 4
5 55 5

I have many rows like this and I would like to do this
<=a1*b1+a2*b2+a3*b3+a4*b4+a5*b5 without typing all of that out.

Ryan