Need help...

2 posts / 0 new
Last post
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.

Calculating letters in a row to give a sum total

I want to calculate the day's work, but I have letters in the row. I also need to calculate the number off days off wich is mark by an "x" in the row.

TUE WED THU FRI SAT SUN MON TUE WED THU FRI SAT SUN MON Total Hours Days worked Days off
1 2 3 4 5 6 7 8 9 10 11 12 13 14
L L/M E/M L E L X X E L E X X X 9 5
8 8 12 8 8 6 8 8 8 74

Add new comment