"Sam" wrote:
I need to keep a running total of hours that someone uses for
disability. Names will always be sorted and together but everyweek
another entry could be made and new names added.
[....]
I just cannot for the
Column A (Name) Column B (Week Of) Column AC (Hours) Column
AD (Running Total)
Sam 01/01/2012
40 40
Sam 01/08/2012
18 58
Sam 01/15/2012
20 78
Chris 01/15/2012
15 15
Chris 01/22/2012
35 50

It is easiest if you have one blank row above the first name. Thus, suppose
the names start in row 2. Put the following formula into AD2 and copy down
the column:

=IF(A2="","",IF(A2<A1,AC2,AC2+AD1))

If you cannot have a blank row, then simply enter the correct data into
first row, and enter the above formula starting in the next row.