Hello -
I am unsure of the best way to accomplish what I am looking for. I have 2 worksheets, 1 labeled as 'Data' and the other as 'Results'. Here is the info on the 'Data' worksheet:
On the 'Results' worksheet, I need to find the matching option number on the 'Data' worksheet and then sum the number of times that option was used for a particular month.
I am struggling with the best way to do this. Any help would be appreciated.
I am unsure of the best way to accomplish what I am looking for. I have 2 worksheets, 1 labeled as 'Data' and the other as 'Results'. Here is the info on the 'Data' worksheet:
A | B | C | D | E | F | |
1 | Box | 100 | 101 | 102 | 103 | 104 |
2 | Date Completed | 9/1/2023 | 9/15/2023 | 10/5/2023 | 10/12/2023 | 11/3/2023 |
3 | Option 1 | 1 | 1 | 1 | 1 | 1 |
4 | Option 2 | 1 | 1 | |||
5 | Option 3 | 1 | 1 | 1 | ||
6 | Option 4 | 1 |
On the 'Results' worksheet, I need to find the matching option number on the 'Data' worksheet and then sum the number of times that option was used for a particular month.
A | B | C | D | |
1 | Sept | Oct | Nov | |
2 | Option 1 | 2 | 2 | 1 |
3 | Option 2 | 1 | 1 | 0 |
4 | Option 3 | 1 | 1 | 1 |
5 | Option 4 | 1 | 0 | 0 |
I am struggling with the best way to do this. Any help would be appreciated.