Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation based on 2 cols
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation based on 2 cols
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation based on 2 cols
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equity buildup calculation | Excel Worksheet Functions | |||
Is the IRR calculation based on cash flows at beginning of year? | Excel Worksheet Functions | |||
Commission Calculation with IF Stmt. | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |