ExcelBanter - Count number of cells with "CAC"

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count number of cells with "CAC" (https://www.excelbanter.com/excel-discussion-misc-queries/262810-count-number-cells-cac.html)

Janet A. Thompson

Count number of cells with "CAC"

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.

ozgrid.com

Count number of cells with "CAC"

=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
...
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.

Mike

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.

Janet A. Thompson

Count number of cells with "CAC"

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.

All times are GMT +1. The time now is 11:43 AM.