Solved how to find match and count in excel

Hewlett-packard / 6120
November 24, 2019 at 22:55:01
Specs: q, i5 /4GB
How do find the total count number if i just want to look up A Class and that obtained grade A only. Indeed case the answer is 2
Many Thanks

Name Grade obtained
A class C
A class A
B Class B
B Class C
A Class A
A Class B..and so on

See More: how to find match and count in excel

Report •

November 25, 2019 at 02:57:16
✔ Best Answer
I believe you are looking for a COUNTIFS()
with your data like:

       A     B
1) A class   C
2) A class   A
3) B Class   B
4) B Class   C
5) A Class   A
6) A Class   B

Use the formula: =COUNTIFS(A1:A6,"A class",B1:B6,"A")

See how that works for you.

Also, if you need to post data please read this HOW-TO which explains the use of < PRE > tags to align the data.


message edited by mmcconaghy

Report •

November 25, 2019 at 03:45:23
You are a star! Thanks very much for the help

Report •
Related Solutions

Ask Question