Need to count Non-Blank cell depends on another two cell criteria

[saps19]

Dear All,

I have a excel containing the below data:

A B C D E F
1 Points Score Cricket Teams Score Points
2 3 122 AAA BBB 100 0
3 1 114 DDD CCC 114 1
4 0 150 EEE FFF 153 3
5 0 129 AAA CCC 130 3
6 N/A EEE DDD N/A
7 N/A FFF AAA N/A
8 N/A DDD AAA N/A
9 N/A CCC BBB N/A
10 N/A BBB FFF N/A
11 N/A BBB EEE N/A
12 N/A CCC AAA N/A

Excel / Picture attached for more info.
Capture.JPG

Now I want to calculate how many matches are played based on non-blank / blank cells, Team Names and Score.

That means the functions (countif / counta) will calculate the non-blank cell first, then search total C2:D12 range with Criteria as AAA or BBB or CCC etc.

So in this case it should return:
AAA played 2 match out of 6 match.
BBB played 1 match out of 4 match
CCC played 2 match out of 4 match and so on...

I tried

Please Login or Register  to view this content.

with CountA function, but not able to sort it out.

Please help me regarding this.

If you guys have any better suggestion, please feel free to discuss .

Regards,
Saps

[zbor]

Look here:

[saps19]

@zbor: Awesome! Worked like a bliss!

Thanks a lot.

Please make this thread as Resolved!

[zbor]

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[saps19]

Ok, I'll wait for some days and after that I will describe the solution and make the post as Resolve!