Are there a way (formula) to count (in a range) cells that contains text (skip blank cells and cells containing numbers)?
Are there a way (formula) to count (in a range) cells that contains text (skip blank cells and cells containing numbers)?
Last edited by maujor; 08-12-2010 at 07:58 PM.
=counta(a1:a10) - count(a1:a10)
Entia non sunt multiplicanda sine necessitate
Another possibility:
=COUNTIF(A:A,"?*")
use of ? assumes you wish to discount formula nulls (ie treat as blank)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks