Function Formula using cells in named Range

Hi,

I'm desperately hoping there is a function for this!

I have a range named IncomeRegion. (b11:g18). Columns c:d (merged) are validation lists with different IncomeTypes, e.g. Vending Commission Inhouse. Column F contains the cash amount receieved. I would like a function that loops thru the c:d column of the range, checks for the variable say "Vending Commission Inhouse", grabs the amount in F, and Sums all Amounts accordingly.

Thanks for any assistance!

Enter as an Array, Ctrl-Shift-Enter instead of Enter

=SUM((C11:D18="vending commission inhouse")*(F11:F18))

of course you can refer to a cell containing the text instead of typing "vending commission inhouse"