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 |