Help with: Selecting numbers to add based on the row below

[SamP]

Could someone please help me figure out, how I should go about this. I am tring to add the values associated with the letter below.

Book1.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Vacation		V																		Vactionhoursused	Vacationhoursleft	Flexhoursused	Flexhoursleft	FloatingHolidayshoursused	FloatingHolidayshoursleft
2	FlexDay		F
3	FloatingHoliday		H
4
5
6			1	2	4	5	6	7	8	9	22	23	24	25	26	27	28	29	30	31	0	120	0	40	0	16
7	January	Hours				8		4		4		3				1			5
8		Code				V		H		F		F				H			V
Sheet1

For example. there is a V under a value of 8 and a value of 5. I want to add then together and put the sum in a cell.
Any ideas??

 

[KenWright]

=SUMPRODUCT(--(C7:T7="V"),(C8:T8))

 

[SamP]

=SUMPRODUCT(--(C7:T7="V"),(C8:T8))

Thanks for the help. It did not work that way but when i made it
=SUMPRODUCT(--(C8:T8="V"),(C7:T7))
It worked like a champ.

Thanks
Sam

 

[KenWright]

Dohhh - my apologies, but you obviously twigged the syntax