I have a worksheet/form which is being used to track time spent on specialty
details in my office. The user needs to indicate which days of the month are
work days and will then have to show how much time they are spending away
from their normal job for these specialty assignments. Many people with
different work
schedules will be using this form. I want to come up with a formula that
can add hours in a column where the work days are denoted by a W. Non work
days will be blank.

Example:
W W W (Indicates work days)
1 2 3 4 5 6 7 (Days of Month)

5 2 1 2 (Hours worked per day of the week)

In this example, I am only interested in computing the hours showing under
the W column. In another calculation, I would also like to compute the hours
which show up in the column without the W.