Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif
Hi
I have these formulas in the following cells, F100 (=IF(ISBLANK('New Conference Office Sheet'! B24),"",'New Conference Office Sheet'!B24)) T100 (=COUNTIF($F$99:F100,"<""")) Why is the Countif function including F100 in the count when it returns a value of "" ? Thanks. |
#2
|
|||
|
|||
I suppose it is returning F100 because F100 is Not Empty.
Try T100 =COUNTIF($F$99:F100,""&0) HTH "nc" wrote in message ... Hi I have these formulas in the following cells, F100 (=IF(ISBLANK('New Conference Office Sheet'! B24),"",'New Conference Office Sheet'!B24)) T100 (=COUNTIF($F$99:F100,"<""")) Why is the Countif function including F100 in the count when it returns a value of "" ? Thanks. |
#3
|
|||
|
|||
Because the cell is not empty. Having no value is not the same.
You could try =SUMPRODUCT(--(LEN($F$99:F100)0)) -- HTH RP (remove nothere from the email address if mailing direct) "nc" wrote in message ... Hi I have these formulas in the following cells, F100 (=IF(ISBLANK('New Conference Office Sheet'! B24),"",'New Conference Office Sheet'!B24)) T100 (=COUNTIF($F$99:F100,"<""")) Why is the Countif function including F100 in the count when it returns a value of "" ? Thanks. |
#4
|
|||
|
|||
Thanks that works.
-----Original Message----- Because the cell is not empty. Having no value is not the same. You could try =SUMPRODUCT(--(LEN($F$99:F100)0)) -- HTH RP (remove nothere from the email address if mailing direct) "nc" wrote in message ... Hi I have these formulas in the following cells, F100 (=IF(ISBLANK('New Conference Office Sheet'! B24),"",'New Conference Office Sheet'!B24)) T100 (=COUNTIF($F$99:F100,"<""")) Why is the Countif function including F100 in the count when it returns a value of "" ? Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
countif statement | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
Countif ??? | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |