Hi there.

I have got a column of which each cel contains one of three answers.
They are either 'O' 'I' or 'P'.

In another cell i need a forumla that will count how many 'O's, 'I's
etc there are.

How do i do this please.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Use the COUNTIF function.

--
David Hager
Excel MVP

"digitallifeform" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Hi there.
>
> I have got a column of which each cel contains one of three answers.
> They are either 'O' 'I' or 'P'.
>
> In another cell i need a forumla that will count how many 'O's, 'I's
> etc there are.
>
> How do i do this please.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>

=SUMPRODUCT((A1:A20={"O","T","P"})+0)

for all

=COUNTIF(A:A20,"O")

for Os only

replace O with T or P to get the individual counts for each of them

--

Regards,

Peo Sjoblom


"digitallifeform" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Hi there.
>
> I have got a column of which each cel contains one of three answers.
> They are either 'O' 'I' or 'P'.
>
> In another cell i need a forumla that will count how many 'O's, 'I's
> etc there are.
>
> How do i do this please.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>

Digital life form?

Try

=COUNTIF(A2:A8,"p")

It's not case sensitive. Make another for the I's, etc. Or make a pivot
table, which will group all the like things it finds and give you a sum,
count, etc. for each group.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"digitallifeform" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Hi there.
>
> I have got a column of which each cel contains one of three answers.
> They are either 'O' 'I' or 'P'.
>
> In another cell i need a forumla that will count how many 'O's, 'I's
> etc there are.
>
> How do i do this please.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>

Thanks v much guys

Yeah i use digitallifeform, and have done for years : )

If you ever play an online game, im on there somewhere!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

=COUNTIF(A1:A20,{"O","I","P"}), array entered into a three-column row,
will return the number of o's, i's, and p's, respectively, to the three
cells; it is not case sensitive.

=SUM(COUNTIF(A1:A20,{"O","I","P"}) will return the aggregate number of
o's, i's, and p's, as will =COUNTA(A1:A20).

Alan Beban

digitallifeform wrote:
> Hi there.
>
> I have got a column of which each cel contains one of three answers.
> They are either 'O' 'I' or 'P'.
>
> In another cell i need a forumla that will count how many 'O's, 'I's
> etc there are.
>
> How do i do this please.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>