Perform Calculation based on multi-criteria matching and lookup value

I'm trying to calculate the amount over a daily meal reimbursement rate IFF all meals on a given day were personal meals (i.e. the individual didn't buy someone else's meal). In the attached example, all meals being personal meals would include blanks or a "No" in the "Group Expense" column. If they selected a "Yes" for either breakfast or lunch or dinner, no calculation would be performed.

For example, the total spent on meals in the example is $83.79. The daily limit is $70. If these meals were all personal (i.e. a blank/no response was provided in the Group Expense column), $13.79 would be returned in the highlighted cell (K6). If they selected a "Yes" for either breakfast or lunch or dinner (or any combination thereof) $0 (or blank) would display in the highlighted cell (K6).

Thus far I've been trying to combine IF statements, with OR statements, with Index/Match using multiple criteria.

I've tried to match expense totals between the "input area" and "summary area" (the summary area is populated from the input area using index/match already), then match the dates between input area and summary area, then match the meal type between input area and summary area, and then look for any "Yes" responses in the input area. If ANY YES responses exist (hence my attempt at incorporating an OR statement), DO NOT show any amount over the daily $70 rate; otherwise calculate the excess.

Examples of some of the formulas I've tried are shown in the attached.

I would appreciate some expert advice!

Thanks,

A