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