Running totals

chuckles1066

Banned
Joined
Dec 20, 2004
Messages
372
Evening everybody,

I have a spreadsheet which needs to show running totals.

Column A contains workman (sorted), column B contains hours worked and column C will show the running total.

What I am doing currently is, starting at the top (there's a header row), entering into c2

=sum(b$2:b2) and dragging it down

Problem is, the workmen in column A keep changing and so I then have to go into column c and change the formula.

Is there a quick way to do this?
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
Problem is, the workmen in column A keep changing and so I then have to go into column c and change the formula.

Is there a quick way to do this?


what do you mean the workmen keep changing? Why does that matter with the sum formula?
 

jmthompson

Well-known Member
Joined
Mar 31, 2008
Messages
966
Do you just want to total the hours by workman? If so, have you tried subtotals?
 

chuckles1066

Banned
Joined
Dec 20, 2004
Messages
372
Sorry, I didn't explain myself properly.

In column D there is week ending and all this data pulls through into a report.

So someone can run a report for week ending 4th March and it will tell them hours worked by workman along with their running total (or year-to-date total if that makes more sense).
 

Forum statistics

Threads
1,141,018
Messages
5,703,756
Members
421,313
Latest member
Mooncake1

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
Top