Cost Per Person Per Attendance

[stevenlee]

I don't know really how to describe this but I'll do my best. I am trying to figure out the total cost each player owes based on attendance throughout the season.

Team Cost: $165
Per Player Cost: *Based on how many players show up on a given day*
Player Total Cost: *Based on how many players show up on a given day and if that player was in attendance they would owe that per player cost for that given day*

Thanks!

Cost

Player Name

11/9

11/16

11/23

12/7

12/14

12/21

1/4

1/11

1/18

1/25

2/1

2/8

2/15

2/22

3/1

3/8

Player Total

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Player 1

$0.00

Team Cost

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

$165.00

Per Player Cost

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Cost
2	Player Name	11/9/2024	11/16/2024	11/23/2024	12/7/2024	12/14/2024	12/21/2024	1/4/2024	1/11/2024	1/18/2024	1/25/2024	2/1/2024	2/8/2024	2/15/2024	2/22/2024	3/1/2024	3/8/2024	Player Total
3	Player 1	X		X		X												$ 209.00
4	Player 2			X		X												$ 44.00
5	Player 3			X														$ 16.50
6	Player 4		X	X		X												$ 99.00
7	Player 5			X														$ 16.50
8	Player 6			X		X												$ 44.00
9	Player 7		X	X														$ 71.50
10	Player 8			X		X												$ 44.00
11	Player 9			X														$ 16.50
12	Player 10			X		X												$ 44.00
13	Player 11																	$ -
14	Player 12		X															$ 55.00
15	Player 13																	$ -
16	Player 14				X													$ 33.00
17	Player 15				X													$ 33.00
18	Player 16				X													$ 33.00
19	Player 17																	$ -
20	Player 18																	$ -
21	Player 19				X													$ 33.00
22	Player 20				X													$ 33.00
23	Player 21																	$ -
24
25	Team Cost	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00	$ 165.00
26	Per Player Cost	$ 165.00	$ 55.00	$ 16.50	$ 33.00	$ 27.50	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Sheet5

Cell Formulas
Range	Formula
R3:R23	R3	=SUM(B$26:Q$26*(B3:Q3="X"))
B26:Q26	B26	=IFERROR(B25/COUNTIF(B3:B23,"x"),0)

 

[stevenlee]

I don't know who you are but you get 3 gold stars and 10 points. Feel free to send me your email and happy to send a Starbucks gift card or something.

Thanks!

 

[Eric W]

Happy to help!

And I appreciate the thought, but this is an all volunteer forum. Feel free to pay it forward to someone else though.