Hi
My current formula only counts the number of times a month appears in the range
=COUNTIFS($B$1:$G$52,">=01/01/2020",$B$1:$G$52,"<01/02/2020")
What I would like to do is specify a cell that contains a "Name" then have it count how many times that name has data associated with it in the range.
For example: Bob appears 3 times
Better still would be to have another cell specify the month.
For example Bob AND April count is two.
I'm thinking this could be some index match??
My current formula only counts the number of times a month appears in the range
=COUNTIFS($B$1:$G$52,">=01/01/2020",$B$1:$G$52,"<01/02/2020")
What I would like to do is specify a cell that contains a "Name" then have it count how many times that name has data associated with it in the range.
For example: Bob appears 3 times
Better still would be to have another cell specify the month.
For example Bob AND April count is two.
I'm thinking this could be some index match??
Name | Dates | ||
Bob | 01/04/2020 | 05/04/2020 | 12/06/2020 |
Tim | 02/03/2020 | 01/06/2020 | 07/06/2020 |
Sarah | 09/04/2020 | etc | etc |