=IF(COUNTBLANK(A4:A120)=117,"",your formula)


--

Regards,

Peo Sjoblom


"Jay" wrote in message
...
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,