SUMIF with date Question? - Maybe

[terminal euphoria]

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

 

[Bob Umlas]

=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)

 

[Teethless mama]

For Pump1:
=SUMPRODUCT(--(INT(A2:A11)=--"8/28/2008"),B2:B11)

For Pump2:
=SUMPRODUCT(--(INT(A2:A11)=--"8/28/2008"),C2:C11)

 

[Peo Sjoblom]

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

 

[terminal euphoria]

Thaks - this was excatly what I wanted

For Pump1:
=SUMPRODUCT(--(INT(A2:A11)=--"8/28/2008"),B2:B11)

For Pump2:
=SUMPRODUCT(--(INT(A2:A11)=--"8/28/2008"),C2:C11)

 

[Teethless mama]

You're Welcome!

Thaks - this was excatly what I wanted