ananddalal
New Member
- Joined
- Aug 8, 2017
- Messages
- 1
Hello, Please advise how do I use multiple COUNTIFS formula to count the number of times individual name is displayed for each of the quarters. I have pasted the desired result below. Will appreciate your help.
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
3Q2019 | 4Q2019 | 1Q2020 | |
John | 2 | ||
Harry | 3 | ||
Noel | 2 | 1 | 1 |
Scott | 1 | 2 | |
3/31/2020 | John | ||
12/31/2019 | Harry | ||
10/31/2019 | Harry | ||
8/31/2019 | Noel | ||
3/31/2020 | John | ||
12/31/2019 | Harry | ||
10/31/2019 | Noel | ||
8/31/2019 | Scott | ||
3/31/2020 | Noel | ||
12/31/2019 | Scott | ||
10/31/2019 | Scott | ||
8/31/2019 | Noel |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>