Excel 2010 SUMIFS / #DIV/0! formula issue 1

[ITALIAORIANA]

Hi,

I am having a problem with a SUMIFS formula and #DIV/0!.

This works fine but it returns #DIV/0! in some cells which I don't want to display.
=SUMIFS('CO Detail'!$D:$D,'CO Detail'!$C:$C, "=20: Assigned - For Estimate",'CO Detail'!$A:$A, B33)/D15

I tried to get the #DIV/0! cells to display a "-"
=IF(ISERROR(SUMIFS('CO Detail'!$D:$D,'CO Detail'!$C:$C,"=20: Assigned - For Estimate",'CO Detail'!$A:$A,H33)/J15),"-",SUMIFS('CO Detail'!$D:$D,'CO Detail'!$C:$C,"=20: Assigned - For Estimate",'CO Detail'!$A:$A,H33)/J15)

With adding the "ISERROR" it now displays a "-" in all cells instead of just the #DIV/0! ones. Any help would be greatly apprciated.

Thanks
Deana

 

[zelgar]

=IF(D15<>0,SUMIFS('CO Detail'!$D:$D,'CO Detail'!$C:$C, "=20: Assigned - For Estimate",'CO Detail'!$A:$A, B33)/D15,"")

 

[ITALIAORIANA]

Thanks Zelgar, that works perfectly.