counting

F

fomula problems

I would like to show the number of 1's, M's, A's and blank cells in a column,
can anyone help.
Alan
 
C

CLR

="1's="&COUNTIF(A:A,1)&CHAR(10)&"M's="&COUNTIF(A:A,"m")&CHAR(10)&"A's="&COUN
TIF(A:A,"a")

Format for Wrap-Text

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Switch - Dollars to Words 0
Find and replace macro for Special ^p - MS Word 0
Section and Page numbering 0
How to count the numbers in a Word document? 0
Duplicate entry in a column/row 14
Find #N/A in column D 2
Help With Typing Russian Letters On Microsoft Word Mac 0
Excel does not accept text format! 0

Top