One way to quickly / easily suppress extraneous zeros from showing:
Click Tools Options View tab Uncheck Zero values OK
(I'd go for this option)

If we want the formula in V10 to return blank when the result is zero,
think we'd need to put instead in V10:

=IF(SUM(IF(LEFT($D10:$Q10,1)=V$9,--SUBSTITUTE($D10:$Q10,V$9,"")))=0,"",SUM(I
F(LEFT($D10:$Q10,1)=V$9,--SUBSTITUTE($D10:$Q10,V$9,""))))

with the formula array-entered, as before

Note that the curly braces { } around the formula have to be inserted by
Excel upon array-entering. We *don't* type these curly braces into the
formula <g

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"DC" wrote in message
...
Max,
Thank you very much!!!
This did the trick...

One last thing, I tried to use an =IF statement to make the formula cell
blank if the value is 0, but for some reason it did not work. It gave me
the #Name error.
Here is what I tried, please let me know if I did something wrong.

=IF(S10=0,"",{=SUM(IF(--(LEFT($D10:$Q10,1)=S$9),--SUBSTITUTE($D10:$Q10,S$9,"
")))})

Thanks again,
David