Calculation based on 2 cols

[burnsbyrne]

I have a file that looks like this

Key ATB Time: Start: Difference
hip 8:22 8:49 0:27
Knee 15:15 15:40 0:25
cabg 12:35 12:58 0:23
etc.

Difference equals (Start) - (ATB Time)
Values of the columns are hour:minute

I need to count how many of the "Difference" values are less than 1:00 for each of the values in the "Key" column. In other words, how many "hips" had "Difference" values that were <1:00.

I'm sure there is a formula to do this but it's one of those things that if you don't know the answer you can't ask the right question.

Thanks in advance for any help!

Mike

[Vincnet.]

Par exemple :
=SOMMEPROD((A2:A7="hip")*(D2:D7<TEMPS(1;0;0)))
--
A+

V.


"burnsbyrne" wrote:

>
> I have a file that looks like this
>
> Key ATB Time: Start: Difference
> hip 8:22 8:49 0:27
> Knee 15:15 15:40 0:25
> cabg 12:35 12:58 0:23
> etc.
>
> Difference equals (Start) - (ATB Time)
> Values of the columns are hour:minute
>
> I need to count how many of the "Difference" values are less than 1:00
> for each of the values in the "Key" column. In other words, how many
> "hips" had "Difference" values that were <1:00.
>
> I'm sure there is a formula to do this but it's one of those things
> that if you don't know the answer you can't ask the right question.
>
> Thanks in advance for any help!
>
> Mike
>
>
> --
> burnsbyrne
>
>
> ------------------------------------------------------------------------
> burnsbyrne's Profile: http://www.excelforum.com/member.php...o&userid=22153
> View this thread: http://www.excelforum.com/showthread...hreadid=564329
>
>

[Sloth]

En Englais si vous plait

=SUMPRODUCT((A2:A4="hip")*(D2:D4<1/24))
or
=SUMPRODUCT((A2:A4="hip")*(D2:D4<TIME(1,0,0)))

I'm just kidding about the language. It took me a second to figure out what
formulas you were using.

"Vincnet." wrote:

> Par exemple :
> =SOMMEPROD((A2:A7="hip")*(D2:D7<TEMPS(1;0;0)))
> --
> A+
>
> V.
>
>
> "burnsbyrne" wrote:
>
> >
> > I have a file that looks like this
> >
> > Key ATB Time: Start: Difference
> > hip 8:22 8:49 0:27
> > Knee 15:15 15:40 0:25
> > cabg 12:35 12:58 0:23
> > etc.
> >
> > Difference equals (Start) - (ATB Time)
> > Values of the columns are hour:minute
> >
> > I need to count how many of the "Difference" values are less than 1:00
> > for each of the values in the "Key" column. In other words, how many
> > "hips" had "Difference" values that were <1:00.
> >
> > I'm sure there is a formula to do this but it's one of those things
> > that if you don't know the answer you can't ask the right question.
> >
> > Thanks in advance for any help!
> >
> > Mike
> >
> >
> > --
> > burnsbyrne
> >
> >
> > ------------------------------------------------------------------------
> > burnsbyrne's Profile: http://www.excelforum.com/member.php...o&userid=22153
> > View this thread: http://www.excelforum.com/showthread...hreadid=564329
> >
> >