Confusing Problem
 

I have a cell with an equation:

[=sum(if(sheet1A1:A100,1,0))]

in sheet1 cells A1:A10, I have a second equations that says:

=if(B1=0,"",C1)

The problem is the first sum function counts the cells with the "" as
being a number that is greater than zero.

However, if I manually delete the information in the cells that had a
"" entered from the second equation, I noticed it does not count the
cell as being greater than zero.

Why does Excel consider the value of a cell to be greater than zero
when the contents of the cell are blank from the second equation.

How do I get Excel to not consider this to be greater than zero?


--
Cincy
------------------------------------------------------------------------
Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172
View this thread: http://www.excelforum.com/showthread...hreadid=561217

Confusing Problem
 

Try

=SUM(IF((Sheet1!A1:A100)*(Sheet1!A1:A10<""),1,0) )

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Cincy" wrote in
message ...

I have a cell with an equation:

[=sum(if(sheet1A1:A100,1,0))]

in sheet1 cells A1:A10, I have a second equations that says:

=if(B1=0,"",C1)

The problem is the first sum function counts the cells with the "" as
being a number that is greater than zero.

However, if I manually delete the information in the cells that had a
"" entered from the second equation, I noticed it does not count the
cell as being greater than zero.

Why does Excel consider the value of a cell to be greater than zero
when the contents of the cell are blank from the second equation.

How do I get Excel to not consider this to be greater than zero?


--
Cincy
------------------------------------------------------------------------
Cincy's Profile:
http://www.excelforum.com/member.php...o&userid=35172
View this thread: http://www.excelforum.com/showthread...hreadid=561217

Confusing Problem
 

Have you tried:

=COUNTIF(SHEET1!A1:A10,"0")
?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Cincy" wrote in
message ...

I have a cell with an equation:

[=sum(if(sheet1A1:A100,1,0))]

in sheet1 cells A1:A10, I have a second equations that says:

=if(B1=0,"",C1)

The problem is the first sum function counts the cells with the "" as
being a number that is greater than zero.

However, if I manually delete the information in the cells that had a
"" entered from the second equation, I noticed it does not count the
cell as being greater than zero.

Why does Excel consider the value of a cell to be greater than zero
when the contents of the cell are blank from the second equation.

How do I get Excel to not consider this to be greater than zero?


--
Cincy
------------------------------------------------------------------------
Cincy's Profile:
http://www.excelforum.com/member.php...o&userid=35172
View this thread: http://www.excelforum.com/showthread...hreadid=561217