Sum Based on Multiple Criteria

[Fireflying]

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

 

[Michael M]

Where is the data for the hours flown for each tail stored ?

 

[Fireflying]

Where is the data for the hours flown for each tail stored ?

I don't think I have that yet...maybe that's my rub! I'm kinda new at this!

I tried a screen shot but it didn't work.

The data is stored in the next column over in F.

 

[ratanbhushan2910]

Do you have sample file?

 

[Michael M]

Ok, so I'm guessing you want a cumulative total for each tail ??
Is the data in rows down each column?

 

[chetanmehra1989]

will u please elborate me without formula so that i could create formula for this one

 

[Fireflying]

How do I post a screen shot?
It doesn't want to cooperate and I'm having trouble explaining myself without a picture

 

[Michael M]

Download the html Maker in my tag to allow you to post a shot of your data..
But you didn't answer either of my questions

 

[Fireflying]

oh, sorry about that Michael...

I'm so new to this message board stuff.

Yes and yes, I need a total for each tail number and the data is in a column next to it.

I may have figured it out and looks something like this:

=SUMIF(D8:D35,"N23241",G8:G35)


I'm working on your most recent instructions and hope to have that to you asap!

 

[Michael M]

If it's a cumulative total, I think you're going to need to use VBA with a Worksheet_Change event