Solved how to find match and count in excel

Hewlett-packard / 6120
November 24, 2019 at 22:55:01
Specs: q, i5 /4GB
HI
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

Reply ↓  Report •

#1
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.

https://www.computing.net/howtos/sh...

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

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

Reply ↓  Report •
Related Solutions


Ask Question