=IF(ISERROR(your function),[your text - a zero or "empty string"],(your
function))

wazooli

"Jay" wrote:

What I need to do is trap for when there is no data,
when there is no data show either "Empty String" or 0, instead of the dreaded
#Value! or #DIV/0! error message. Here is the formula:

=SUMPRODUCT(--('A
Shift'!$A$4:$A$120="A"),--(TEXT('A Shift'!$B$4:$B$120,"mmm-yy")="Mar-05"),('A
Shift'!$D$4:$D$120))/SUMPRODUCT(--('A Shift'!$A$4:$A$120="A"),--(TEXT('A
Shift'!$B$4:$B$120,"mmm-yy")="Mar-05"))

Any assistance will be appreciated.

Thanks,