help adding up hour totals on a logbook
 

Hi,
I have created a logbook to log my flights and want to add up different
aircraft totals.
example column A2 contains type eg B747-300, B747-400 etc.
Column R2 contains flight time.
I was trying to create a formula that looks at A2 and if it contains say
B747-300 then put the value of R2 in a new table column -300, similarly for
the -400 etc.
so I can get the totals for each type, hope this makes sense????

help adding up hour totals on a logbook
 

There are a number of posts in this forum which give similar solutions using
SUMPRODUCT function. Try to search for them

Basically you have to enter a formula like this one to get the totals;
=SUMPRODUCT(--(A1:A100="B747-300"),(R1:R100))

Adjust the range according to your data points. In Excel 2007 you can use
A:A and R:R for range...

"joe1999" wrote:

Hi,
I have created a logbook to log my flights and want to add up different
aircraft totals.
example column A2 contains type eg B747-300, B747-400 etc.
Column R2 contains flight time.
I was trying to create a formula that looks at A2 and if it contains say
B747-300 then put the value of R2 in a new table column -300, similarly for
the -400 etc.
so I can get the totals for each type, hope this makes sense????

help adding up hour totals on a logbook
 

THANKS!! Sheeloo works perfect your a star :D

"Sheeloo" wrote:

There are a number of posts in this forum which give similar solutions using
SUMPRODUCT function. Try to search for them

Basically you have to enter a formula like this one to get the totals;
=SUMPRODUCT(--(A1:A100="B747-300"),(R1:R100))

Adjust the range according to your data points. In Excel 2007 you can use
A:A and R:R for range...

"joe1999" wrote:

Hi,
I have created a logbook to log my flights and want to add up different
aircraft totals.
example column A2 contains type eg B747-300, B747-400 etc.
Column R2 contains flight time.
I was trying to create a formula that looks at A2 and if it contains say
B747-300 then put the value of R2 in a new table column -300, similarly for
the -400 etc.
so I can get the totals for each type, hope this makes sense????