If your current formula is correct when all 18 cells are filled with numbers,

=SUM(A1:C6)*COUNT(A1:C6)/100

On Tue, 19 Oct 2004 20:49:19 GMT, "Jean-Paul De Winter"
wrote:

Hi,
Suppose I have a range from A1 to C6.
I need to calculate a % out of these 18 cells
The formula I use is: (sum(A1:C6)*18)/100
This works perfectly if all cells contain a value, but what if some cells
are left empty....
What should the formula be in that case??
Thanks