Micky
New Member
Joined: Dec 21, 2016
Follow
RE: count blank and special character
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 co...
8 years ago
RE: count blank and special character
A bit shorter formula would be: =COUNTA(A1:A9)-COUNTIF(A1:A9,"") Micky
8 years ago