Confusing Problem

[Cincy]

I have a cell with an equation:

[=sum(if(sheet1A1:A10>0,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 "" a
being a number that is greater than zero.

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

Why does Excel consider the value of a cell to be greater than zer
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

 

[Bob Phillips]

Try

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

--
HTH

Bob Phillips

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

 

[Ragdyer]

Have you tried:

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