Hi
I'm using this sumproduct formula to access a closed workbook.

=SUMPRODUCT((('QO'!$J$12:$J$500="SQ")*(TEXT('QO'!$E$12:$E$500,"mmmm")=TEXT($B51,"mmmm"))),'QO'!$F$12:$F$500)
In some circumstances the result can be a negative number, in this case I'd like it to return a 0 (zero).

your help would be appreciated