Hi,

I have the following formula: 

=SUMPRODUCT((name=C4)*(dob=E4)*(MONTH(month)=MONTH(B4)))
This bascially checks how many occurances a youth (based on name and dob) has been reported this momnth (Month). The only problem is with this is it calculates blank entries. I have copied down the formula to 500 rows so it shows 500 occurances of the blanks.

So is there any way to hide blank entries to prevent them showing as a total?

Thank you in advance,

JP