Try this array formual** :
Assumes that every cell that contains a "V" is *always* followed by a
number.
="v"&SUM(IF(LEFT(C2:G2)="V",--MID(C2:G2,2,5)))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)