| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with date Question? - Maybe
You're Welcome!
"terminal euphoria" wrote: Thaks - this was excatly what I wanted "Teethless mama" wrote: For Pump1: =SUMPRODUCT(--(INT(A2:A11)=--"8/28/2008"),B2:B11) For Pump2: =SUMPRODUCT(--(INT(A2:A11)=--"8/28/2008"),C2:C11) "terminal euphoria" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif date is greater than or equal chosen date | Excel Discussion (Misc queries) | |||
| Sumif....date in table is greater than compared to date | Excel Discussion (Misc queries) | |||
| SUMIF Question | Excel Worksheet Functions | |||
| Year To Date Sumif question | Excel Discussion (Misc queries) | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Threaded Mode
