Counting different value's

[digitallifeform]

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.

 

[David Hager]

Use the COUNTIF function.

 

[Peo Sjoblom]

=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

 

[Earl Kiosterud]

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.

 

[digitallifeform]

Thanks v much guys

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

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

 

[Alan Beban]

=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