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.
<tbody>
</tbody>
A | B | C | D | E | |
1 | <first quarter> | <second quarter> | <third quarter> | <fourth quarter> | <total score> |
2 | 10 | 30 | 5 | 5 | 50 |
3 | 50 > | <score calculation> |
<tbody>
</tbody>