Counting in Multiple columns

Closed
Alax - Sep 29, 2009 at 01:52 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 29, 2009 at 05:51 AM
Hi All,

I am a new Excel user. Can someone help me in getting solution to below
problem:

I have following data:

Grade Suject1
A 80
B 80
C 50
A 90
B 70
A 80

How can I

1. Count only Grade is "A" and score is "80"
2. Count only Grade is "A" and "B" and score is ">=70"

Thanks, Alax

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 29, 2009 at 05:51 AM
=SUMPRODUCT(($A$1:$A$6="A")*($B$1:$B$6=90))

if it is ok say "yes"
0