sum 2 different criteria in the same cell

[rowrow780]

hello - i am trying to sum the number after each letter. the total sum will be added to the correct cell.
example: employee takes V1 ( vacation 1 hour ) and also P4 (sick time). the total hours for each type will be under the correct total hours ( column AH AI AJ )

is this possible to do? I am not sure what formula to use for this one . or is it better to put each type of time off in its own cell?
( Thank you Eric who helped me with the original question! )

 

[lrobbo314]

How about this?

VSP
	A	B	C	D	E	F
1				Vac	Sick	PD
2	Test 1	v1 p4		1		4
3	Test 2	v2 s1 p3		2	1	3
4	Test 3	s1 p14			1	14
Sheet6

Cell Formulas
Range	Formula
D2:F4	D2	=LET(o,$B2&" ",v,SEARCH(LEFT(D$1),o)+1,IFERROR(INT(MID(o,v,FIND(" ",o,v)-v)),""))

 

[rowrow780]

thank you i will try it!