"Dinesh" wrote:
Tried..that was just a typo..didn't work.

Perhaps you meant to do it as:
=IF(SUMPRODUCT(--($D$6:$D$1055="M"),--($L$6:$L$1055="New"),--($N$6:$N$1055="Cisco
Systems Capital Australia
P/L"))=0,"",SUMPRODUCT(--($D$6:$D$1055="M"),--($L$6:$L$1055="New"),--($N$6:$N$1055="Cisco Systems Capital Australia P/L")))

If so, think it's easier/better to dispense with the error trap,
i.e. use just:
=SUMPRODUCT(--($D$6:$D$1055="M"),--($L$6:$L$1055="New"),--($N$6:$N$1055="Cisco Systems Capital Australia P/L"))

and just suppress extraneous zeros from display in the sheet via:
Tools Options View tab Uncheck "Zero values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---