Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUM.IF...probable fingertrouble
Hi all Having problems with Excel sorting info, depending on other info. The case is a flight logbook, and my mission is to accumulate the hours flown on different types of aircraft into seperate columns. The idea for the code is: A column is aircraft type H column is hours flown G column is accumulated aircraft hours flown if P28A is in column A6, then insert hours:minutes from H6 into field G50. If G115 is in column A7, then insert hours:minutes from H7 into field G51. if P28A is in column A8, then insert hours:minutes from H8 into field G50. if anyone has an idea, please please respond. Borken, Denmark -- Borken ------------------------------------------------------------------------ Borken's Profile: http://www.excelforum.com/member.php...o&userid=26276 View this thread: http://www.excelforum.com/showthread...hreadid=395669 |
#2
|
|||
|
|||
Custom format Column G to:
[h]:mm So that the total hours exceeding 24, won't roll over into days. Then, either of these should work for you: =SUMPRODUCT(($A$2:$A$100=A6)*$H$2:$H$100) =SUMIF($A$2:$A$100,A6,$H$2:$H$100) Copy up and/or down as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Borken" wrote in message ... Hi all Having problems with Excel sorting info, depending on other info. The case is a flight logbook, and my mission is to accumulate the hours flown on different types of aircraft into seperate columns. The idea for the code is: A column is aircraft type H column is hours flown G column is accumulated aircraft hours flown if P28A is in column A6, then insert hours:minutes from H6 into field G50. If G115 is in column A7, then insert hours:minutes from H7 into field G51. if P28A is in column A8, then insert hours:minutes from H8 into field G50. if anyone has an idea, please please respond. Borken, Denmark -- Borken ------------------------------------------------------------------------ Borken's Profile: http://www.excelforum.com/member.php...o&userid=26276 View this thread: http://www.excelforum.com/showthread...hreadid=395669 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|