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"))



Todd Nelson wrote:

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"))

--

Dave Peterson

I need it to calculate the blank cells as well, i think it is more of a cell
format error


"Dave Peterson" wrote:

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"))



Todd Nelson wrote:

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"))

--

Dave Peterson

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.



Todd Nelson wrote:

I need it to calculate the blank cells as well, i think it is more of a cell
format error

"Dave Peterson" wrote:

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"))



Todd Nelson wrote:

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"))

--

Dave Peterson


--

Dave Peterson