Multiplies and SUMMARIZE columns

[Gabriell]

Hi,


I'd like to multiply the values in column C by those in column E and display the sum in cell F2 without creating an additional column for the intermediate results.

Is there a solution for this problem?

 

[hagia_sofia]

In 365:

=SUM(C5:C8*E5:E8)

 

[Gabriell]

Hmmm. It was easy like 1+1. Exactly what I needed.
Thank you!