As long as every cell that contains a "v" also contains a number. Try this
array formula** :

=SUM(IF(LEFT(A1:C1)="v",--MID(A1:C1,2,5)))

I'm guessing that "v" means Vacation, "s" means Sick for timesheet
calculations.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Stacy" wrote in message
...
In a row the values would ranging from v4 to v8, how would I add all the
values that starts with v? So if col a would appear v8, column b would be
v8
and column c would be s8, how will I add only the columns that starst with
v?
Thus, I would need the sum in column f showing v16?