djmixer135
New Member
- Joined
- Nov 19, 2018
- Messages
- 13
Hi there,
I have two sheets on a workbook - a summary table and a master record table.
For each record on my master table, I want to add it to a count on my summary sheet (see below).
<tbody>
</tbody>
<tbody>
</tbody>
Whilst I would normally perform this task using COUNTIFS(), this function does not support the functions MONTH() and YEAR(). Instead, I am using SUMPRODUCT.
So far, my count is working as expected for the 'Name' and 'Date' criteria. However, I would like to add a drop-down menu alongside my summary table allowing the user to select the summary of the different record types. 'Cat A', 'Cat B' or 'ALL CATEGORIES'.
Does anyone know how I would be able to do this?
Thanks in advanced!
I have two sheets on a workbook - a summary table and a master record table.
For each record on my master table, I want to add it to a count on my summary sheet (see below).
Summary Table | Jan | Feb | Mar | Apr | May |
Name 1 | 0 | 0 | 0 | 0 | 0 |
Name 2 | 0 | 0 | 0 | 0 | 0 |
Name 3 | 1 | 1 | 0 | 0 | 0 |
Name 4 | 0 | 0 | 1 | 0 | 0 |
<tbody>
</tbody>
Name | Date | Type |
Name 3 | 01/01/2018 | Cat A |
Name 3 | 01/02/2018 | Cat B |
Name 4 | 01/03/2018 | Cat A |
<tbody>
</tbody>
Whilst I would normally perform this task using COUNTIFS(), this function does not support the functions MONTH() and YEAR(). Instead, I am using SUMPRODUCT.
So far, my count is working as expected for the 'Name' and 'Date' criteria. However, I would like to add a drop-down menu alongside my summary table allowing the user to select the summary of the different record types. 'Cat A', 'Cat B' or 'ALL CATEGORIES'.
Does anyone know how I would be able to do this?
Thanks in advanced!