EricTheRed
New Member
- Joined
- Oct 22, 2019
- Messages
- 1
Hi, all!
I've got a calendar-style sheet (sheet 3) that I'm pulling data from, and I've got the categories in 2 different dropdown menus on a second sheet (sheet 4). I'm trying to get a cell to add up all of the occurrences of certain text within the calendar.
I've figured out how to accomplish this with one dropdown menu because I can just have it referencing individual rows, but I can't quite get the second dropdown to influence which row it's pulling from.
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=SUMPRODUCT(--EXACT(C10, Sheet3!4:4))
C10 is the first dropdown menu. H10 is the second dropdown menu, and it should help select the row being referenced on sheet 3. I tried using INDEX, but I think I did it incorrectly.
Any help is much appreciated!
[/FONT]
I've got a calendar-style sheet (sheet 3) that I'm pulling data from, and I've got the categories in 2 different dropdown menus on a second sheet (sheet 4). I'm trying to get a cell to add up all of the occurrences of certain text within the calendar.
I've figured out how to accomplish this with one dropdown menu because I can just have it referencing individual rows, but I can't quite get the second dropdown to influence which row it's pulling from.
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=SUMPRODUCT(--EXACT(C10, Sheet3!4:4))
C10 is the first dropdown menu. H10 is the second dropdown menu, and it should help select the row being referenced on sheet 3. I tried using INDEX, but I think I did it incorrectly.
Any help is much appreciated!
[/FONT]
