Count number of cells with "CAC"

J

Janet A. Thompson

I have a spreadsheet. One column has cells that have either A, CAC, or Other.

How can I have Excel enter the number of each type of cell in ONE cell?
 
M

Mike

Maybe this will help
="Count of A is :" &COUNTIF(A1:A10,"A")& " Count of CAC is: "
&COUNTIF(A1:A10,"CAC")
 

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

I have Invoice 1 and2 I need to post to 1 and print iems on 2 2
COUNT function - # of occurences a number appears in all cells 26
Counting Letters 2
Common Access Card for dod application 1
Count with merged cells 2
Adding Cells 4
count cells in a document, but excude cells with a "0" 1
CountIf Function Help 9

Top