fluffy cabbage
New Member
- Joined
- Jun 3, 2002
- Messages
- 9
Hi there,
I have a Players database for a sports association I run - in the database, among other information, I have listed what team(s) each child is playing on and what tshirt size they will need for each team.
I am using the COUNTIF formula to determine how many players I have in each division. I would now like to count how many of each tshirt size in each division I need - so I need a formula that basically says something like COUNTIF Jane is in T-ball AND wears a YS shirt. I've tried several different things, but I'm not coming up with the right result.
There are some of the same shirt sizes across different divisions, so I need to be able to count for each division, not just total of one size.
I hope this is explained clearly enough!
Thanks in advance,
Fluffy
I have a Players database for a sports association I run - in the database, among other information, I have listed what team(s) each child is playing on and what tshirt size they will need for each team.
I am using the COUNTIF formula to determine how many players I have in each division. I would now like to count how many of each tshirt size in each division I need - so I need a formula that basically says something like COUNTIF Jane is in T-ball AND wears a YS shirt. I've tried several different things, but I'm not coming up with the right result.
There are some of the same shirt sizes across different divisions, so I need to be able to count for each division, not just total of one size.
I hope this is explained clearly enough!
Thanks in advance,
Fluffy