| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count if question | Excel Worksheet Functions | |||
| COUNT QUESTION | Excel Discussion (Misc queries) | |||
| Count Question | Excel Discussion (Misc queries) | |||
| {=COUNT(IF(etc))} question | Excel Discussion (Misc queries) | |||
| Count Question | Excel Worksheet Functions | |||
Hybrid Mode
