thebenjames
New Member
- Joined
- Mar 12, 2021
- Messages
- 12
- Office Version
- 2019
- Platform
- Windows
Unsure if using COUNTIFs is the right way as I've read SUMPRODUCT may be a better solution, but here goes..
I have 2 tables of data, one of which contains some client information including a date (column Q) and a postcode (column K), and another which contains a very long list of postcodes and whether they are considered 'dangerous'. I need to count how many of the clients in the first sheet have a date which falls between a range (as below), but only if their postcode is included in the 'dangerous' list..
Please let me know if you need any more information
I have 2 tables of data, one of which contains some client information including a date (column Q) and a postcode (column K), and another which contains a very long list of postcodes and whether they are considered 'dangerous'. I need to count how many of the clients in the first sheet have a date which falls between a range (as below), but only if their postcode is included in the 'dangerous' list..
Date range | Number of clients |
01/08/2017-31/07/2018 | |
01/08/2018-31/07/2019 | |
01/08/2019-31/07/2020 | |
01/08/2020-31/07/2021 |
Please let me know if you need any more information