Hi
I'm using this sumproduct formula to access a closed workbook.
In some circumstances the result can be a negative number, in this case I'd like it to return a 0 (zero).=SUMPRODUCT((('QO'!$J$12:$J$500="SQ")*(TEXT('QO'!$E$12:$E$500,"mmmm")=TEXT($B51,"mmmm"))),'QO'!$F$12:$F$500)
your help would be appreciated
Bookmarks