Count number of cells with "CAC"

  • Thread starter Thread starter Janet A. Thompson
  • Start date Start date
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?
 
Maybe this will help
="Count of A is :" &COUNTIF(A1:A10,"A")& " Count of CAC is: "
&COUNTIF(A1:A10,"CAC")
 
Back
Top