I have a variable list of items in date order, there could be one, more than one, or, no items for any one date
Each item has it's own line
I need a formula in a separate column (column F) to total each day's items ...
Column A includes the Date
Column F is a cumulative total (as in Column C) for items on the same date
Column C=D+E
I am looking for a formula which will add up items in column C if they have the same date in column A, and put the answer in the last cell in column F for that date. Any ideas?
Example
A B C D E F
03-04-09 G Faherty 48.60 8.60 40.00 48.60
04-04-09 I Sexton 56.35 6.35 50.00 56.35
05-04-09 A Bell 41.45 11.45 30.00 41.45
06-04-09 M Trott 54.00 4.00 50.00
06-04-09 A Aaron 58.15 8.15 50.00 112.15
08-04-09 M Seaton 28.35 8.35 20.00
08-04-09 D Brown 52.45 2.45 50.00 80.80
09-04-09 H Mills 50.55 0.55 50.00
09-04-09 I Sexton 52.10 2.10 50.00 102.65
10-04-09 A Bailey 46.50 6.50 40.00
10-04-09 H Mills 52.15 2.15 50.00
10-04-09 T O' sullivan 52.30 2.30 50.00
10-04-09 D Brown 54.05 4.05 50.00
10-04-09 R B Murthy 52.20 2.20 50.00
10-04-09 M Seaton 57.95 7.95 50.00
10-04-09 C Hart 58.45 8.45 50.00 373.60
11-04-09 P Cook 55.35 5.35 50.00
11-04-09 M Hart 67.05 17.05 50.00
11-04-09 I Sexton 53.10 3.10 50.00 175.50
12-04-09 M Seaton 59.00 9.00 50.00
12-04-09 M Barber 5.25 5.25 0.00 64.25
13/04/09 M Trott 52.45 2.45 50.00
13/04/09 D Flanders 53.20 3.20 50.00 105.65
Thank you very much for any help
Kind regards
T
Bookmarks