Sumproduct DIV/0 Error

[D Whitney]

I have the following sumproduct formula that works on a subset of the target
range, but returns a #DIV/0! error for the full range below (i.e. it works
for rows 112 to 2122 & 3776 to 6730, does not work if rows 2123 to 3775 are
included).

=SUMPRODUCT(--('BS Details'!$D$112:$D$6730=$F$2),--('BS
Details'!$H$112:$H$6730=$A512),'BS Details'!I$112:I$6730)

The format of the data in the target range was brought in from another
workbook. Any ideas on what could be in the range of data that could be
causing this result?

Thanks,
DWhitney

 

[David Biddulph]

You don't get a #DIV/0! error from the SUMPRODUCT function as such. The
error must be in one or more of the cells being fed into the formula.

 

[joel]

Sumproduct doesn't divide, which means one of the cell in the range has a
divide by zero. find the error on the worksheet.

 

[Mike H]

Try

=SUMPRODUCT((I6:I9999)*(B6:B9999<>"F"))

Mike

 

[Mike H]

wrong thread-

Try

=SUMPRODUCT((I6:I9999)*(B6:B9999<>"F"))

Mike

 

[D Whitney]

This worked.
Thanks!

Sumproduct doesn't divide, which means one of the cell in the range has a
divide by zero. find the error on the worksheet.