Multiplying entire columns

[Nanaia]

Is there a way to multiply every cell from Column D19 through D50 by their corresponding numbers in column G19 through G50 and adding the totals? i.e. =(D19*G19)+(D20*G20)+(D21*G21)+(D22*G22)+(D23*G23)+(D24*G24)+(D25*G25)+(D26*G26)...etc.? I'm doing it long-hand but thought there may be a way to simplify.
Thanks.

 

[tyija1995]

Hey,

SUMPRODUCT will achieve this!

=SUMPRODUCT(D19:D50,G19:G50)

 

[Nanaia]

You're a ROCK STAR!!! Thank you!