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
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,693
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. 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
19,693
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows

ADVERTISEMENT

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

ADVERTISEMENT

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
19,693
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. 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
19,693
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
If it's a cumulative total, I think you're going to need to use VBA with a Worksheet_Change event
 

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,964
Members
413,955
Latest member
FalcoDaz

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
Top