How do i count numbers and letters to find a total count of al
Thanks PCLIVE.
"PCLIVE" wrote:
Linda,
I'm not sure that a formula can count the number of characters in a range of
cells. However, here is a formula that will count the number of characters
in a single cell (A1).
==IF(A1="","",LEN(A1))
If A1 is blank, then the result will be blank. This will include spaces in
the count. If you want to omit spaces in the count, then:
=IF(A1="","",LEN(SUBSTITUTE(A1," ","")))
This only couts characters without spaces.
Fill down as needed, and then use a SUM fuction in another cell to get a
total count.
HTH,
Paul
"Linda" wrote in message
...
I do not want zeros to just show up when nothing has been put in a cell.
But
I want 0's to show up when entered in to the cell. Then I want to count
all
whether it is a number or text. Is there any way to count all in a group
of
columns to get just the count?
|