Count same text from different rows

[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.)

 

[Bob Phillips]

=SUMPRODUCT(($A$1:$A$5="Q1")*($B$1:$E$5="a"))

etc.

 

[Mike H]

Try this

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

Cahnge the criteria for your other counts

Mike