I'm trying to sum hour many flight hours I have loaded in a spreadsheet. The insurance company wants various totals. The one I'm having trouble with the number of hours in a plane with retractable gear. How can I sum the flight time for all the planes that have retract time? I tried a SUMIFS, but I can't get that to work. Any ideas?
thanks
Here is what the table of planes looks like:
<colgroup><col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2929;">
<col width="62" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2190;" span="2">
<col width="60" style="width: 45pt; mso-width-source: userset; mso-width-alt: 2133;">
<col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2360;">
<col width="82" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2901;">
<tbody>
</tbody>
Here is what the Log looks like:
<colgroup><col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2929;">
<col width="62" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2190;" span="2">
<tbody>
</tbody>
thanks
Here is what the table of planes looks like:
Model # | Tail # | Category | Complex | High Perf. | Retract Gear |
C182Q | N12345 | ASEL | No | Yes | No |
PA46-350P | N11224 | ASEL | Yes | Yes | Yes |
PA46T-DLX | N11224 | ASEL | Yes | Yes | Yes |
PA32R-301T | N00001 | ASEL | Yes | Yes | Yes |
PA28A-181 | N00002 | ASEL | No | No | No |
PC-12/47 | N55DD | ASEL | Yes | Yes | Yes |
SIMPRO | SIMPRO1 | ASEL | No | Yes | No |
PC-12/47Sim | SIM500 | ASEL | Yes | Yes | Yes |
Here is what the Log looks like:
Aircraft | Flight Time | |
Make & Model | Tail Number | H:M |
PA28A-181 | N36700 | 1.00 |
C182Q | N97523 | 1.10 |
PA46-350P | N744RV | 1.10 |
PA46T-DLX | N744RV | 0.90 |
PA32R-301T | N4187D | 1.20 |
PC-12/47 | N51DJ | 1.20 |
PA46-350P | N744RV | 2.00 |
PA46T-DLX | N744RV | 1.00 |
PA28A-181 | N36700 | 1.10 |
SIMPRO | SIMPRO1 | 2.10 |
pc-12/47Sim | FAA1373 | 1.40 |