how do i get the sum of data from specific dates
So just sort by the date and do data|subtotals. You'll see each day's total.
huffmjb wrote:
Cells do not contain any time
Below is a sample of the sheet, I am exporting this data into excel from SAP
so the layout is what I get.
I am lookin for a way to get a sum for column B,C & D for each day (ie:
2006/01/01)
There are many entries for each day.
A B C D
2006/01/01 8 8 9
2006/01/01 8 9 9
2006/01/01 6 6 4
2006/01/02 5.5 5 5
2006/01/02 8 5 6
2006/01/02 9 5 6
2006/01/02 10 8 7
2006/01/03 7 6 7
"Dave Peterson" wrote:
If you sort by column A, you can use Data|subtotals to add up those hours.
If the hours are really cells containing time (5:00 or 7:30), then format the
subtotals as [h]:mm.
It'll avoid a problem if the subtotals exceed 24 hours.
Or you may want to look into Data|pivottable.
huffmjb wrote:
Column A has dates eg: 2006/01/01, 2006/01/02 with many entries for each date.
Column B, C, D has data of hours used on these dates.
I am looking for a way to get the sum of each column specific to a date
(daily totals)
--
Dave Peterson
--
Dave Peterson
|