Calcultae % with empty cells
 

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

Calcultae % with empty cells
 

Jean-Paul,

Try:

Sum(A1:C6)*Count(A1:C6)/100

HTH,
Nikos

"Jean-Paul De Winter" wrote in message
...
Hi,
Suppose I have a range from A1 to C6
I need to calculate a % out of these 18 cells
I currently use the formula: (sum(A1:C6)*18)/100
This is correct if all cells contain a value, but whet if 3 cells are left
empty???
What should the formula be in that case?
Thanks
JP

Calcultae % with empty cells
 

Why not just

=AVERAGE(A1:C6)*100

or =AVERAGE(A1:C6)

and format as percentage

--

HTH

RP

"Nikos Yannacopoulos" wrote in message
...
Jean-Paul,

Try:

Sum(A1:C6)*Count(A1:C6)/100

HTH,
Nikos

"Jean-Paul De Winter" wrote in message
...
Hi,
Suppose I have a range from A1 to C6
I need to calculate a % out of these 18 cells
I currently use the formula: (sum(A1:C6)*18)/100
This is correct if all cells contain a value, but whet if 3 cells are
left
empty???
What should the formula be in that case?
Thanks
JP

Calcultae % with empty cells
 

oops, forget that, losing it!

--

HTH

RP

"Bob Phillips" wrote in message
...
Why not just

=AVERAGE(A1:C6)*100

or =AVERAGE(A1:C6)

and format as percentage

--

HTH

RP

"Nikos Yannacopoulos" wrote in message
...
Jean-Paul,

Try:

Sum(A1:C6)*Count(A1:C6)/100

HTH,
Nikos

"Jean-Paul De Winter" wrote in message
...
Hi,
Suppose I have a range from A1 to C6
I need to calculate a % out of these 18 cells
I currently use the formula: (sum(A1:C6)*18)/100
This is correct if all cells contain a value, but whet if 3 cells are
left
empty???
What should the formula be in that case?
Thanks
JP