how do i get the sum of data from specific dates
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
|