Total Sum Broken Into Parts

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]
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,223,710
Messages
6,174,019
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top