# Sum Based on Multiple Criteria

#### Fireflying

##### New Member
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?

Thanks!

Fireflying

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Where is the data for the hours flown for each tail stored ?

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:
Do you have sample file?

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

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

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:
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

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!

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

Replies
9
Views
591
Replies
1
Views
297
Replies
3
Views
795
Replies
9
Views
543
Replies
1
Views
929

1,214,258
Messages
6,118,524
Members
448,830
Latest member
Drew Terp

### 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.

### Which adblocker are you using?

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

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