#Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am calculating percentages and in one cell the formula works and in the
next it gives me a #value error, the formulas match perfectly just different
cells. Can anyone explain this. This is the formula
=IF(E11:E14="",0,SUMIF(E11:E14,">0")/COUNTIF(E11:E14,">0"))
 
You sure you don't want a formula like:

=IF(COUNT(E11:E14)=0,0,SUMIF(E11:E14,">0")/COUNTIF(E11:E14,">0"))
or even:
=IF(COUNTIF(E11:E14,">0")=0,0,SUMIF(E11:E14,">0")/COUNTIF(E11:E14,">0"))
 
I need it to calculate the blank cells as well, i think it is more of a cell
format error
 
I don't think you'll have any luck playing with the format.

And I'm not sure what you mean about calculating the blank cells, too. An empty
cell could be treated as 0, but your formula looks at cells > 0.
 
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

dividing 0 by 0 in excel 2003 10
Returning Desired Results 5
Macro help 5
Why does "=SUM(E4,E8,E11,E14,E17)" display as text? 4
The specified formula cannot be entered because it uses more levels of nesting than are allowed in t 7
Help with solving this if statement which uses a search for text s 9
#VALUE! Error 4
Formula Fill Problems 6

Back
Top