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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,224,747
Messages
6,180,719
Members
452,995
Latest member
isldboy

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