July 16, 2010
Hi Micky,
Great to see you having a go, however that formula counts everything except the blank cell. Rathanak wants to also count the special characters.
If you wanted to make mine shorter you could always use:
=SUM(--NOT(ISNUMBER(A1:A9)))
And enter with CTRL+SHIFT+ENTER.
But I don't recommend array formulas unless you have to use them.
Mynda
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
New Member
December 21, 2016
Mynda Treacy said
Hi Micky,Great to see you having a go, however that formula counts everything except the blank cell. Rathanak wants to also count the special characters.
If you wanted to make mine shorter you could always use:
=SUM(--NOT(ISNUMBER(A1:A9)))
And enter with CTRL+SHIFT+ENTER.
But I don't recommend array formulas unless you have to use them.
Mynda
Hi,
Yes, I noticed some small TIPOs in my previous suggested formula.
As per the question - I assumed the OP has a mixed list of Numbers/Special Characters/empty cells.
For that I would try another formula, such as: =COUNT(A1:A9)+COUNTIF(A1:A9,"")
Micky
1 Guest(s)