Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with date Question? - Maybe
=SUMPRODUCT(N(A2:A11=Datevalue("8/28/08")),N(B2:B11="Pump1),B2:B11)
=SUMPRODUCT(N(A2:A11=Datevalue("8/28/08")),N(B2:B11="Pump2),B2:B11) "terminal euphoria" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with date Question? - Maybe
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with date Question? - Maybe
That will fail in all countries but the US and maybe Canada, the
international format for dates is SUMPRODUCT(--(INT(A2:A11)=--"2008-08-28"),B2:B11) which will work in the US as well -- Regards, Peo Sjoblom "Teethless mama" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with date Question? - Maybe
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 |
#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 |
Reply |
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 |