Try this:

=SUMIF(1:1,"W",4:4)

I've assumed your W's are in row 1 and your hours worked are in row 4.

Hope this helps.

Pete

On Aug 27, 2:41*pm, Lee Ann <Lee
wrote:
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.