melodramatic
Board Regular
- Joined
- Apr 28, 2003
- Messages
- 187
- Office Version
- 365
- Platform
- Windows
OK, I know this is easy, but it's escaping me today.
I've got a Lottery table for our group, and part of my calculation of winnings distribution is dependent on how many people have played that month. January thru October is easy - if you paid, you played. About November, we start using our winnings credit to pay our monthly play, so it's not as easy to count.
What I need to be able to do is count how many people paid to play in the Lotto (Col D), as well as how many people played using their credit (Col E), but I don't want to double-count those who paid and used some credit.
So, what I want is for cell D4 to give me the calculation of anyone who has either paid or used balance. The total should be 16, but how do I get there?
Thanks so much in advance!
I've got a Lottery table for our group, and part of my calculation of winnings distribution is dependent on how many people have played that month. January thru October is easy - if you paid, you played. About November, we start using our winnings credit to pay our monthly play, so it's not as easy to count.
What I need to be able to do is count how many people paid to play in the Lotto (Col D), as well as how many people played using their credit (Col E), but I don't want to double-count those who paid and used some credit.
So, what I want is for cell D4 to give me the calculation of anyone who has either paid or used balance. The total should be 16, but how do I get there?
Thanks so much in advance!