Sunshine8790
Board Regular
- Joined
- Jun 1, 2021
- Messages
- 86
- Office Version
- 365
- Platform
- Windows
I have a sheet (I cannot share due to privacy) with 2 tabs.
The first tab has 10 columns:
Name, Shift, Contest Shift, Contest Day, Building, Supervisor, #Votes for Scariest, #Votes for Most Original, #Votes for Funniest, Outfit
There are 50+ Rows of data with the info of participants and corresponding info other than the #votes cells.
The 2nd tab has 4 columns:
Voter name, Vote for (participant name), Shift Day, Category
I currently have this formula in cell G2 (Votes for Scariest on first participant), which was a pain to create because I also had to manually type in each name on all 3 cells on row 2 for that person as well as change "Scariest" to "funniest" or "Most original" in the other columns, and repeat that process for each row for the different participants.
Bear in mind, some participated more than one day so their names come up more than once.
(Real name in formula changed to Jane Doe)
Currently the formula I have is not working properly. It's showing me some results - but not all. Can someone please help me fix the one I have or help me come up with another?
The first tab has 10 columns:
Name, Shift, Contest Shift, Contest Day, Building, Supervisor, #Votes for Scariest, #Votes for Most Original, #Votes for Funniest, Outfit
There are 50+ Rows of data with the info of participants and corresponding info other than the #votes cells.
The 2nd tab has 4 columns:
Voter name, Vote for (participant name), Shift Day, Category
I currently have this formula in cell G2 (Votes for Scariest on first participant), which was a pain to create because I also had to manually type in each name on all 3 cells on row 2 for that person as well as change "Scariest" to "funniest" or "Most original" in the other columns, and repeat that process for each row for the different participants.
Bear in mind, some participated more than one day so their names come up more than once.
Excel Formula:
=COUNTIFS(Votes!$B:$B,"Jane Doe",Votes!$C:$C,"Tuesday Day",Votes!$D:$D,"Scariest")Currently the formula I have is not working properly. It's showing me some results - but not all. Can someone please help me fix the one I have or help me come up with another?
