Counting different value's

  • Thread starter Thread starter digitallifeform
  • Start date Start date
D

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.
 
=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
 
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.
 
Thanks v much guys

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

If you ever play an online game, im on there somewhere!
 
=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
 
Back
Top