From: Janet A. Thompson on 29 Apr 2010 21:57 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. From: ozgrid.com on 29 Apr 2010 22:03 =COUNTIF(A:A,"CAC") or =COUNTIF(A:A,B1) where B1 houses your text. -- Regards Dave Hawley www.ozgrid.com "Janet A. Thompson" wrote in message news:EC5E3F85-DAE7-4174-9182-FAD9DE244E1B(a)microsoft.com...>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. From: Mike on 29 Apr 2010 22:07 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. From: Janet A. Thompson on 29 Apr 2010 23:30 Where is the count of "Other" -- and is A1:A10 your example of the range of the spreadsheet? Janet A. "Mike" wrote: > 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.  |  Pages: 1 Prev: from "date" to "text"Next: Excel VB application