Thread: function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default function?

=SUMPRODUCT(E4:E8,C4:C8)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RT" wrote in message
...
Is there a Function for this formula??


=(E4*C4)+(E5*C5)+(E6*C6)+(E7*C7)+(E8*C8)