| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf & null values problem
Hello all, Small prolem with Countif. I have a function that counts if a cell is not blank - i.e has text in it: =countif(v2:v200,"bob") For some reason even if text is there it doesn't get counted. Now the formula for cells where "bob" might appear is below: =IF(D50,(IF(ISBLANK(L5)=TRUE,"bob","")),"") This formula works fine but i have a suspicion it affects the countif. Any suggestions?? Thanks, Chris -- chris100 ------------------------------------------------------------------------ chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166 View this thread: http://www.excelforum.com/showthread...hreadid=490689 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying null values in charts | Charts and Charting in Excel | |||
| COUNTIF / SUM problem | Excel Worksheet Functions | |||
| Using COUNTIF to check values in multiple columns | Excel Worksheet Functions | |||
| COUNTIF or SUMIF Problem | Excel Discussion (Misc queries) | |||
| IF IS NULL PROBLEM | Excel Worksheet Functions | |||
Threaded Mode
