justinr321
New Member
- Joined
- Nov 26, 2016
- Messages
- 3
I have a list of 100 names, 1 = Fred, 2 = David
Assume this is a lottery, each week we draw 3 names and these are listed in a row on sheet 1 next to Y/N depending if they collect their prize, e.g.
Week | Name 1 | Prize 1 | Name 2 | Prize 2 | Name 3 | Prize 3
Week 1 | Fred | Y | David Y | Etc | N
Week 2 | Fred | N | David Y | Etc | N
On Sheet 2 I have a simple COUNTIF to show how many time Fred has won, e.g. =COUNTIF(Sheet1!B$2:AM$100,Fred)
Which would show 2 in this example, but how do I combine functions to show that Fred has 1 win, prize = N?
Assume this is a lottery, each week we draw 3 names and these are listed in a row on sheet 1 next to Y/N depending if they collect their prize, e.g.
Week | Name 1 | Prize 1 | Name 2 | Prize 2 | Name 3 | Prize 3
Week 1 | Fred | Y | David Y | Etc | N
Week 2 | Fred | N | David Y | Etc | N
On Sheet 2 I have a simple COUNTIF to show how many time Fred has won, e.g. =COUNTIF(Sheet1!B$2:AM$100,Fred)
Which would show 2 in this example, but how do I combine functions to show that Fred has 1 win, prize = N?