View Single Post
  #3  
Old February 20th, 2006, 10:57 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default 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