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
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
Bookmarks