I have a workbook composed of various sheets. The main thing I am trying to do is obtain values for one sheet from another sheet based on various conditions. The other sheet must SUM all the columns where travel month = October and Travel = Domestic(this is just one condition). The column contains travel for all months, but I only want to SUM the column's values where the corresponding cells meet the aforementioned conditions(travel month = October and Travel = Domestic). I have tried numerous things, Sumif, if, just to name a few.

[FONT='Segoe UI', Tahoma, Verdana, Arial, sans-serif]Right now it's summing [/FONT]**everything**[FONT='Segoe UI', Tahoma, Verdana, Arial, sans-serif] if it gets an occurrence of October and Domestic as opposed to just the cells where these conditions are met. I have attached my example. The actual sheet is the one where I need to place the accurate formula(specifically I am only trying for formulas in D24:D27 at this time) and the travel sheet contains the data that I am searching for. [/FONT]

Actuals D24 should equal 800

Actuals D25 should equal 1000

Actuals D26 should equal 11800

Actuals D27 should equal 11400

I previously tried this: =IF(Travel!$J7:Travel!$J51="October",IF( Travel!$G7:Travel!$G51="Domestic",SUM(Travel!$M7:Travel!$M51), 0), 0) as the formula for Actuals D24

One other thing to note, the travel sheet will increase in rows as additional travel occurs so I have to either have the formula as dynamic OR I just need to make the range larger than what I expect it to increase to.

Can anyone be of assistance?

Thanks in advance