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

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