1. Easiest option is to suppress extraneous zeros display in the sheet:
Click Tools Options View tab
Uncheck "Zero values" OK, done!

2. An alternative is to use a simple IF** construct, eg:
=IF(SUMPRODUCT(($I$10:$I$20=C$1)*($H$10:$H$20=$A2) )=0,"",SUMPRODUCT(($I$10:$I$20=C$1)*($H$10:$H$20=$ A2)))

**the downside is this will increase the calc load and may affect
performance especially for heavy duty functions like sumproduct where large
ranges are involved. Although in your case here, it shouldn't be material
since the ranges are small.

Your choice ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"OKY" wrote in message
...
Max ,

I made couple changes and it works great.
Thank you very much.
I noticed that on the cells where nothing is entered a zero shows up. How
do
I get rid of if? I need something to make the cells C and D blank when no
text is input in the H:I range.
That will be my last request.

thanks max.