Need help...

Hello all,

I'm trying to come up with a formula which will sum the values of named cells based on whether a user answers Y or N for some criteria in a table.

Table:

Travel Meal Allowances
Arrival Departure
B L D B L D
Y Y Y Y Y Y

The named cells and values are:

BreakfastRate - 17
LunchRate - 17.25
DinnerRate - 45.55

So if any of the above answers are Y, it will sum the values.

Does this make sense?

Thanks in advance.