| Home |
| Search |
| Today's Posts |
|
|
|
#1
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? |
| 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
