SUMIF with date Question? - Maybe

  • Thread starter terminal euphoria
  • Start date
T

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
 
B

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

Teethless mama

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

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

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
 
T

terminal euphoria

Thaks - this was excatly what I wanted

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating average handling time 7
Need help for data mining 4
Problem formatting dates from CSV file 2
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Matching dates to cells 3
Need Formula 2
To Calculate the qty b/w two dates 3
How do I have excel highlight days before & after a date on a cale 2

Top