View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
terminal euphoria terminal euphoria is offline
external usenet poster
 
Posts: 4
Default SUMIF with date Question? - Maybe

I have a number of spreadsheets that I need to find the sum of two columns
that occur during a date period. I want to know the sum for 1 pump & 2 pump
for say 8/28/08. Can you give me any help with this function?

Date/Time 1 pump 2 pump
8/29/08 6:01 7
8/29/08 5:59 10
8/29/08 5:59 8,688
8/29/08 5:59 98,763
8/28/08 21:55 5,666
8/28/08 21:52 31,134
8/28/08 19:20 5,477
8/28/08 19:17 50,952
8/28/08 15:08
8/28/08 15:05 61,275