View Single Post
  #1   Report Post  
Borken
 
Posts: n/a
Default 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