clarkerots
New Member
- Joined
- Mar 29, 2019
- Messages
- 10
I'm creating a scoresheet and I have a cell that will total the score, but I have other cells that I want to list how many points were scored in each quarter. So in the table below, E3 will have the total score of the game. After the first quarter, I want E3 to populate A1 and then stay. After the second quarter, I want E3 to populate B1, and then B1-A1 so that B1 only has the second quarter points. Same for C1 and D1. I've put where I want the data, and sample data bolded underneath that. Everything is on one worksheet. Thank you.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]<first quarter>
[/TD]
[TD]<second quarter>
[/TD]
[TD]<third quarter>
[/TD]
[TD]<fourth quarter>
[/TD]
[TD]<total score>
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10
[/TD]
[TD]30
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]50 >
[/TD]
[TD]<score calculation>
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]<first quarter>
[/TD]
[TD]<second quarter>
[/TD]
[TD]<third quarter>
[/TD]
[TD]<fourth quarter>
[/TD]
[TD]<total score>
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]10
[/TD]
[TD]30
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]50 >
[/TD]
[TD]<score calculation>
[/TD]
[/TR]
</tbody>[/TABLE]