Prev: from "date" to "text"
Next: Excel VB application
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" <JanetA(a)discussions.microsoft.com> 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