COUNT question

[Gerard Sanchez]

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?

 

[Teethless mama]

=IF(ISODD(COUNTIF(B2:B23,">0")),"Unfilled Cell Present",COUNT(B2:B23)/2)

 

[pogiman via OfficeKB.com]

Try this:

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

 

[Gerard Sanchez]

Thank you Teethless mama (lol!). It worked!

=IF(ISODD(COUNTIF(B2:B23,">0")),"Unfilled Cell Present",COUNT(B2:B23)/2)

 

[Teethless mama]

You're Welcome!

Thank you Teethless mama (lol!). It worked!