Forum Discussion

Copper Contributor

Apr 28, 2018

Sumproduct

i have created the following formulas any help so i can write the same in much shorter form =G23*SUMPRODUCT(Consumable!$B$3:$B$28,Consumable!$C$3:$C$28)+G24*SUMPRODUCT(Consumable!$B$3:$B$28,Consuma...

Formulas & Functions

tips and tricks

SergeiBaklan

Diamond Contributor

Apr 28, 2018

Hi Ali,

Could be

=SUMPRODUCT(Consumable!$B$3:$B$28,MMULT(Consumable!$C$3:$L$28,G23:G32))