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
|