Counting Cells that contain text

Mykul69

Good Afternoon,

I'm trying to add columns that only contain text.  I have a column where the users insert "issues" that they have with that particular line item.  At the bottom of the sheet, I need to have a running total of how many issues are listed (and then make a graph) so I am trying to make a formula counting blank vs. non-blank cells.  This is what I have so far but it's coming back #UNPARSEABLE

=countif([open issues]10:[open issues]190,"*")

=countif([open issues]10:[open issues]190,"cell isn't blank")

 

I've also used the same formulas above with "=counta"

 

Any assistance/guidance is greatly appreciated.

 

Thanks in advance,

 

Mike Wilday

Try some combination of these to get your tallies. 

• Count all cells in a range that contain text. Note: This won't count cells that have only numbers. You want to set the column name to the column that does and doesn't have text. 
  
  
  
  =COUNTIF([Open Issues]10:[Open Issues]190, ISTEXT(@cell))
  
   
• Count all cells in a range: You want to count a column that has something in every row. It won't count blank cells. 
  
  
  
  =Count([Your Range]10:[Your Range]190) 

If you subtract the total count from the Is text count you should get the count of items without text in the column... 

https://help.smartsheet.com/function/count