Hello,
I am trying to construct a formula without using any macros and hoping someone can help me out. I have attached a sample workbook with the problem.
I would like a formula on a separate sheet ('Formula') which will consider the following.

If Aircraft!E:E is "Turbo-Propeller" Then use the Aircraft!A:A values to find all matching registrations, in this case C-XXXX, C-YYYY and C-ZZZZ are all Turbo-Propeller.
Using the determined registrations, Lookup if Logbook!C:C matches any of those registrations, to sum the associated row Logbook!Q:Q.

There will be multiple entries for each registration (i.e.: C-XXXX) and I would like all registrations to add up for a total value.
The end result will be a list of all aircraft which are considered "Turbo-Propeller" and will have the values added for each column separately.

Thanks!

Problem.xlsx