SUMIF

[KAB]

My spreadsheet is as follows:

1/3/2005 7:15 AM 8:15 AM 1.00 0:30
8:45 AM 9:45 AM 1.00 0:15
10:00 AM 11:00 AM 1.00 0:00
11:00 AM 12:30 PM 1.50 0:15
12:45 PM 3:45 PM 3.00 0:30
4:15 PM 6:15 PM 2.00

I am attempting to total all time equal to or less than 0:30 in column E
into Column F. Thank you for your assistance...

-KAB

 

[Bob Umlas, Excel MVP]

Your ilustration seemed to only go thru col E. However:
=SUMIF(E1:F1000,"<"&Timevalue("0:30"))

 

[Peo Sjoblom]

=SUMIF(Range1,"<="&(1/48),Range2)

or


=SUMIF(F4:F10,"<="&(1/48),E4:E10)


or


=SUMIF(F4:F10,"<="&TIME(0,30,1),E4:E10)


depending on where the values are




--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

Use < instead of <=

--


Regards,


Peo Sjoblom

=SUMIF(Range1,"<="&(1/48),Range2)

or


=SUMIF(F4:F10,"<="&(1/48),E4:E10)


or


=SUMIF(F4:F10,"<="&TIME(0,30,1),E4:E10)


depending on where the values are




--


Regards,


Peo Sjoblom

 

[KAB]

This returns 0 values, even for time incremented larger than 0:30. What may I
be doing incorrectly?

 

[KAB]

I am getting results of 0, even for those entries greater than 0:30. Thank
you for the response...