COUNT question
 

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?

COUNT question
 

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


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

COUNT question
 

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

COUNT question
 

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


"Teethless mama" wrote in message
...
=IF(ISODD(COUNTIF(B2:B23,"0")),"Unfilled Cell Present",COUNT(B2:B23)/2)


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

COUNT question
 

You're Welcome!


"Gerard Sanchez" wrote:

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


"Teethless mama" wrote in message
...
=IF(ISODD(COUNTIF(B2:B23,"0")),"Unfilled Cell Present",COUNT(B2:B23)/2)


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