View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Count number of cells with "CAC"

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

"Janet A. Thompson" wrote:

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?

--
Janet A.