Thread: array formula (I think)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nibbana nibbana is offline
external usenet poster
  
Posts: 8
Default array formula (I think)
Here's my data:

A B
1 10 120
2 15 80
3 12 30

I need a fast formula that can replace this one:
(A1*B1)+(A2*B2)+(A3*B3) = 2760

Thanks!
Reply With QuoteReply With Quote