function?

[RT]

Is there a Function for this formula??


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

 

[Bernard Liengme]

=SUMPRODUCT(E4:E8,C4:C8)
best wishes

 

[Sheeloo]

=SUMPRODUCT(E4:E8,C4:C8)