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.

The SUMPRODUCT function might help with this.

Thanks ConneXionLost.
I knew there had to be a simplier way, it just goes to reason it would exist.

I was reading on the evolving use on Sumproduct and it looks it has a lot of potential.


Thanks again.