SUMIF for variable cell range

[Pantryman]

I'm still in the blind!

anyone knows how to do this?

In short,

first column containing dates sorted old to new
column 2 containing type information
column 3 containing flying hours

- possible multiple flights on same day; if withing last 90 days, th
should all be counted

< formula should return hours on type in the last n days >

Thanks and sorry to 'bump' this one

 

[Domenic]

=SUMPRODUCT(--(A2:A10>TODAY()-E2),--(B2:B10=D2),C2:C10)

...where D2 contains the "type" of interest and E2 the last "n" days.

Hope this helps