SUM.IF...probable fingertrouble

[Borken]

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 hour
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 fiel
G50.
If
G115 is in column A7, then insert hours:minutes from H7 into fiel
G51.
if
P28A is in column A8, then insert hours:minutes from H8 into fiel
G50.


if anyone has an idea, please please respond.

Borken, Denmar

 

[Ragdyer]

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.