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

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

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

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

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

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