Sum Based on Multiple Criteria

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
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Where is the data for the hours flown for each tail stored ?
 
Upvote 0
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.
 
Last edited:
Upvote 0
Ok, so I'm guessing you want a cumulative total for each tail ??
Is the data in rows down each column?
 
Upvote 0
How do I post a screen shot?
It doesn't want to cooperate and I'm having trouble explaining myself without a picture :(
 
Last edited:
Upvote 0
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
 
Upvote 0
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!
 
Upvote 0
If it's a cumulative total, I think you're going to need to use VBA with a Worksheet_Change event
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,024
Members
448,543
Latest member
MartinLarkin

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