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
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,205
Office Version
2013
Platform
Windows
Where is the data for the hours flown for each tail stored ?
 

Fireflying

New Member
Joined
Sep 8, 2014
Messages
6
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:

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,205
Office Version
2013
Platform
Windows
Ok, so I'm guessing you want a cumulative total for each tail ??
Is the data in rows down each column?
 

Fireflying

New Member
Joined
Sep 8, 2014
Messages
6
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:

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,205
Office Version
2013
Platform
Windows
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

New Member
Joined
Sep 8, 2014
Messages
6
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

Well-known Member
Joined
Oct 27, 2005
Messages
18,205
Office Version
2013
Platform
Windows
If it's a cumulative total, I think you're going to need to use VBA with a Worksheet_Change event
 

Forum statistics

Threads
1,082,589
Messages
5,366,494
Members
400,895
Latest member
Anthonemr

Some videos you may like

This Week's Hot Topics

Top