SUMIF for variable cell range

[Pantryman]

With help of Aladin (see 'vertical search summing up matching offse
data') I determined how to add hours per type

{I'm writing a pilots logbook, where flights are listed starting wit
the date, then followed by several data fields on that same row.
Now, one cell per row ofcourse contains the aircraft type (e.g
B747-400) but several other aircraft types are flown, and I would lik
to determine how many hours are flown per type.
I'd like to do a vertical search in the 'type' column, then for exampl
get the hour flown on that type/that day or the amount of landings mad
and add that up to get the total results. I can do this ofcourse fo
the first matching return, that's easy but I don't know how to get al
the typematching hours added up.)

the solution was

=SUMIF(F31:F5000;A17;K31:K5000) where A17 is the aircraft type, F i
the typerange and K is the hour range.

Now, what's left is getting the hours flown in the last 90 days.
If have done this for the total logbook by

=SUM(OFFSET(A31;MATCH(IF(TODAY()-30<=A31;A31;TODAY()-30);DOF);10;5000;1)
where A31 is the first cell containing a date and DOF is th
dateofflight-range

But the range in SUMIF needs to be predetermined and MATCH will no
return a cell number but simply a number.
So what I'd like to do is convert the MATCH result to a useabl
cellnumber.

Or is there a smarter way?

Regards,

M

 

[Frank Kabel]

Hi
just add the starting row of your lookup range -1 to the result of
MATCH