Hello,
Is there any way to do associated operations in Excel similar to that of Matlab?

In my simplified example, I want to change the tedious formula of "'=$D$3*D16+$E$3*E16+$F$3*F16+$G$3*G16" to something that looks like Rates*Hours, but the rates and hours would for a range of all the columns in the selected area.