Try this:

=IF(mod((CountIf(B2:B23),"0"),2)=0,CountIf(B2:B23 )/2,"Unfilled Cell Present")



Gerard Sanchez wrote:
Hi,

In a range, B2:B23, I would like to count how many values are greater than
zero (0).

If count is an odd number, then "Unfilled Cell Present"
If count if even, then display count divided by 2.

Currently I have:

IF ( (CountIFs(B2:B23),"0")=ODD, "Unfilled Cell Present",
(Count(B2:B23))/2 ))

Problem is the ODD function here is not right . . . I think.

Anyone?

--
Message posted via http://www.officekb.com