| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting text in a column
Thanks Gary.
"Gary''s Student" wrote: You have solved it!!! Use: =IF(B17=0,C18,"") instead of: =IF(B17=0,C18," ") -- Gary''s Student - gsnu200800 "Paul H" wrote: Don't know what going on, your suggested formula doesn't work, the "If" statements is =IF(B17=0,C18," ") the formula counts this cell even when the results are blank, is my If statement causing the problem? "Gary''s Student" wrote: The solution the Bob & I proposed will work for a block of cells none of which are truly empty; that is they all will have text showing or have a formula returning a blank. If this is not the case and the block of cells has both cells with visible text and cells that are truly empty, then just use the COUNTA() function. -- Gary''s Student - gsnu200800 "Paul H" wrote: Gary and Bob, your solution is counting the "If" statement in the cells. I have 1 name (Text) and 30 blank cells and your formula returns 31? "Gary''s Student" wrote: If A1 thru A10 contain either text or formulas returning a blank, then: =COUNTA(A1:A10)-COUNTBLANK(A1:A10) -- Gary''s Student - gsnu200800 "Paul H" wrote: I would like to count the text in a column, (each text would count as 1), the column contains a simple "If" statement that will return either a name or a blank. The text counting solutions I see in these posts also count the If statement as 1. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting text in a column. | Excel Worksheet Functions | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Counting text in a column | Excel Discussion (Misc queries) | |||
| counting text in a column | New Users to Excel | |||
| COUNTING TEXT CELLS IN A COLUMN | Excel Worksheet Functions | |||
Threaded Mode
