ExcelBanter - Column Counts

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Column Counts (https://www.excelbanter.com/excel-discussion-misc-queries/135079-column-counts.html)

Brurobiney

Column Counts

I have a list of 400 items. In Column C are characters that mean different
things. How do I write up a formula that gives me a count of the items that
does NOT have a character in column C?

David Biddulph[_2_]

Column Counts

=COUNTBLANK(C1:C400)
--
David Biddulph

"Brurobiney" wrote in message
...
I have a list of 400 items. In Column C are characters that mean different
things. How do I write up a formula that gives me a count of the items
that
does NOT have a character in column C?

All times are GMT +1. The time now is 02:54 AM.