Sumproduct problem = #DIV/0!

[JESSHOR60]

I need help on my formula as it appear #DIV/0! when I sumproduct Col D , Col B and Divide by Col C.

Thaks

[Jonmo1]

Try this array formula entered with CTRL + SHIFT + ENTER

=SUM(IF(C5:C16<>0,(D5:D16*B5:B16)/(C5:C16),0))

[MagicMan]

Ignore my last message - IT WAS RUBBISH!!

[Special-K]

Does this work?

=SUMPRODUCT(IF(C5:C16=0,0,(D5:D16*B5:B16)/(C5:C16)))
Array formula, use Ctrl-Shift-Enter