Sum Based on Multiple Criteria

F

Fireflying

New Member
Joined
Sep 8, 2014
Messages
6
First time posting...

What I'm trying to do:

I have a drop down box with 4 airplane tail numbers listed (Cell A).

The cell next to it also has a drop down box with the prices (Cell B).

(Cell C) I manually input the variable.

(Cell E ) gives me my total.

Cell A (Dropdown)
N23241
N32251
N6985W
N117VR

Cell B (Dropdown)
$105.00
$115.00

Cell C (variable)
2.0 Hours

Cell E
Total ($230.00)

HERE'S THE QUESTION:
I want a sum of hours flown for each aircraft tail number listed in a separate box.
Example:
N23241 100 Hours
N32251 250 Hours
N66985W 75 Hours
N117VR 35 Hours


Does this make sense?
How do I write this formula? Please help!!

Thanks!

Fireflying
 
Sort by date Sort by votes
IS this what you are looking for?

Thanks for even considering to help me!!


[B]Excel 2007[/B][TABLE]
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>[TR="bgcolor: #E0E0F0"]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[TH]J[/TH]
[TH]K[/TH]
[TH]L[/TH]
[TH]M[/TH]
[TH]N[/TH]
[/TR]
</thead><tbody>[TR]
[TD="align: center"]6[/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]Aircraft Instruction[/TD]
[TD="bgcolor: #DBEEF3, align: center"][/TD]
[TD="bgcolor: #DBEEF3, align: center"][/TD]
[TD="bgcolor: #DBEEF3, align: center"][/TD]
[TD="bgcolor: #DBEEF3, align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]CFI Instruction[/TD]
[TD="bgcolor: #FDE9D9, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="bgcolor: #EEECE1, align: center"]Date[/TD]
[TD="bgcolor: #EEECE1, align: center"]Ticket #[/TD]
[TD="bgcolor: #DBEEF3, align: center"]Aircraft Type[/TD]
[TD="bgcolor: #DBEEF3, align: center"]Tail Number[/TD]
[TD="bgcolor: #DBEEF3, align: center"]Aircraft Rate[/TD]
[TD="bgcolor: #DBEEF3, align: center"]Aircraft Solo HRS[/TD]
[TD="bgcolor: #DBEEF3, align: center"]Aircraft Dual HRS[/TD]
[TD="bgcolor: #DBEEF3, align: center"]Aircraft Cost[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]CFI Rate[/TD]
[TD="bgcolor: #FDE9D9, align: center"]CFI FLT Hours[/TD]
[TD="bgcolor: #FDE9D9, align: center"]CFI GND Hours[/TD]
[TD="bgcolor: #FDE9D9, align: center"]CFI Cost[/TD]
[TD="bgcolor: #D7E4BC, align: center"]Invoice Total[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]PA-28[/TD]
[TD="align: center"]N23241[/TD]
[TD="align: center"]$105.00[/TD]
[TD="align: center"]0.0[/TD]
[TD="align: right"]2.0[/TD]
[TD="bgcolor: #DBEEF3, align: center"]$210.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$210.00[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]N23241[/TD]
[TD="bgcolor: #E5E0EC, align: center"]$105.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"]3.0[/TD]
[TD="bgcolor: #DBEEF3, align: center"]$315.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$315.00[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]N32251[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]1.0[/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]$50.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]35[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="bgcolor: #DBEEF3, align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"]$50.00[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]$0.00[/TD]
[TD="bgcolor: #D7E4BC, align: center"]$0.00[/TD]
[/TR]
[TR]
[TD="align: center"]36[/TD]
[TD="align: center"]TOTALS[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0.0[/TD]
[TD="align: right"]6.0[/TD]
[TD="align: center"]$525.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]0.0[/TD]
[TD="align: center"]0.0[/TD]
[TD="align: center"]$0.00[/TD]
[TD="align: center"]$525.00[/TD]
[/TR]
[TR]
[TD="align: center"]37[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Page 2 of 2[/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]9/10/2014[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]39[/TD]
[TD="bgcolor: #E5E0EC, align: center"]Account Balance & Billing Report[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD]Totals[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Fee[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]Total Flight Hours in Each Aircraft[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]42[/TD]
[TD="bgcolor: #DBEEF3"]Aircraft Instruction OCC[/TD]
[TD="bgcolor: #DBEEF3"][/TD]
[TD="bgcolor: #DBEEF3"][/TD]
[TD="bgcolor: #DBEEF3, align: right"]6.0[/TD]
[TD="bgcolor: #DBEEF3, align: right"]$525.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]N23241[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"]5.0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]43[/TD]
[TD="bgcolor: #FDE9D9"]CFI Instruction Sunrise[/TD]
[TD="bgcolor: #FDE9D9"][/TD]
[TD="bgcolor: #FDE9D9"][/TD]
[TD="bgcolor: #FDE9D9, align: right"]0.0[/TD]
[TD="bgcolor: #FDE9D9, align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]N32251[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]N6985W[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]45[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]Grand Total[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D7E4BC, align: right"]$525.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]N117VR[/TD]
[TD="align: right"]0.0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]46[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]47[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]48[/TD]
[TD]Student Deposits & Credits[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]49[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]50[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]51[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]52[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]53[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]54[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]55[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]56[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]57[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]58[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]59[/TD]
[TD="bgcolor: #E5E0EC, align: center"][/TD]
[TD="bgcolor: #E5E0EC, align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD]Student Account Balance:[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]-$525.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]60[/TD]
[TD]Total:[/TD]
[TD="align: center"]$0.00[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]Student (14)[/B][/COLOR][/CENTER]

 
Upvote 0

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
I feel dumb....

I think I've got it figured out.

I used the sumif formula and replaced each tail number to get a running total.

Cheers!!
 
Upvote 0
:lol:....had we have seen the example earlier, we would have suggested that...:beerchug:
You do realise you could also do it with a Pivot Table.....no formulas !
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Solved
populate data based on multiple criteria
Replies
7
Views
288
Cubist
Cubist
U
  • Question Question
VLOOKUP that will SUM data based on Date Range
2
Replies
18
Views
966
UnitedCloud01
U
E
  • Question Question
Count filtered unique values where sum of values in another column meets criteria
Replies
9
Views
1K
excelhelppleas
E
1
  • Question Question
Sum total filtered data only, with multiple criteria
Replies
1
Views
451
1988craig
1
K
  • Question Question
AVERAGEIFS / SUMIF with multiple criteria
Replies
3
Views
1K
arthurbr
arthurbr

Forum statistics

Threads
1,223,243
Messages
6,170,971
Members
452,371
Latest member
Frana

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top