Forum Discussion
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...
I tried to reproduce your case, no problems with formulas
and in attached file. If still doesn't work please attach sample file
Thanks
it is working much appreciated
i have few blank cells once i replaced with zero it worked perfectly