Calcultae % with empty cells

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

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
 
Why not just

=AVERAGE(A1:C6)*100

or =AVERAGE(A1:C6)

and format as percentage
 
oops, forget that, losing it!

--

HTH

RP

Bob Phillips said:
Why not just

=AVERAGE(A1:C6)*100

or =AVERAGE(A1:C6)

and format as percentage

--

HTH

RP
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate % with empty cells 5
Excel formula, sum the value cell and if empty cell left blank 0
VBA set thick borders around non empty cells in range 0
displaying an empty cell 1
Excel Need Countifs Formula Help 0
= cell above last entered data 8
Macro for copy and paste function 2
Reference a cell in criteria range 2

Back
Top