Would it help if I send you my worksheet? In a row, lets say row 5, I have
the name of the employee on col A5, v8 on col B5, s8 on C5 and v8 on D5...
will it total to v16 (vacation hours) in a different col? and total s8 (sick
hours) in a different column?

"David Biddulph" wrote:

If you have v8 in A1 and v8 in B1, the formula will return v16. What do you
have in A1 and in B1?
--
David Biddulph

"Stacy" wrote in message
...
Hi David,

I tried the formula you gave me but it doesnt sum up the number of
hours....
it only shows v0.... Thank you for replying

Stacy

"David Biddulph" wrote:

="v"&IF(LEFT(A1)="v",RIGHT(A1,LEN(A1)-1),0)+IF(LEFT(B1)="v",RIGHT(B1,LEN(B1)-1),0)
--
David Biddulph

"Stacy" wrote in message
...
Hi David, thank you for replying I have been trying to figure this
formula
out for days now... I am creating a worksheet for sick and vacation
leaves.... v8 will be keyed in a column if the person is in vacation
leave
or
s8 for sick leave (8 for 8hours) and I need to total how many vacation
hours
did the person take in one column hence, v8 + v8 = v16. And more
importantly
I need to only count the v's and s's to sum up.... I am sorry if i dont
make
myself clear...

Stacy

"David Biddulph" wrote:

Firstly, please ask your question in the body of the message rather
than
just in the subject line.

Secondly, you'll need to explain what you mean by
v8(col a), v8(col b), and v16(col c)
--
David Biddulph

"Stacy" wrote in message
...