Hi,

I am doing calcuations mainly multiplications of multiple cells, for
e.g =a1*a2*a3...a10. Cells a1-a5 has some number in it however a6-a10
does not. However it gives me result of 0 if blank cells are also
included in the calculation.

How do I go about calculating so that the blank cells are ignored
unless it has any number in it.

thanks in advance..