Short formula for Multiply and Sum

[sureshsonti]

Hi Guru's
I have 2 columns. One column as hourly rate and other column has hours. I want to get the total. Is there a short formula for the data that I have in the attached spreadsheet. I have thousands of row in my actual data.

Really appreciate your help.

Thanks

 

[bosco_yip]

You could use the Sumproduct function

In F29, enter formula :

=SUMPRODUCT(D4:D26,E4:E26)

 

[sureshsonti]

Hey Bosco,
Really appreciate your help. Thanks again

 

[pecoflyer]

This being said, if you have more than one month to analyze, you should change your layout

 

[simonbellfi]

Thanks, I was also looking for the answer to this question!