Count same text from different rows

  • Thread starter Thread starter kashish
  • Start date Start date
K

kashish

I have database like given below

A B C D E
Q2 a c c a
Q2 b a a a
Q1 d a a
Q2 c a
Q1 d a b a

I want to count how many "a" are there in different column for Q1, or how
many "c" are there in different column for Q2. (Q1 & Q2 are only in A column.)
 
Try this

=SUMPRODUCT((A1:A20="Q2")*(B1:E20="a"))

Cahnge the criteria for your other counts

Mike
 
Back
Top