Hlookup with Multiple of the same value and totally them

[mercedes98]

hi,

I am using Hlookup to find the letting V and when it finds the letter V is gives me the value in the cell under it. The issue is that I may or may not have more than 1 V in the array I am looking at and if there is more than one V then I need it to give me the total.
V V
0.00 8.00 8.00 0.00 0.00 0.00 0.00
=IF(ISNA(HLOOKUP(U9,E31:K32,2,FALSE))=TRUE,"0",HLOOKUP(U9,E31:K32,2,FALSE))
This is the formula I am using but it only gives me one 8 and I need the total of 16.
Can anyone help.

 

[Special-K99]

Try
=sumproduct((E31:K31)="V"*(E32:K32))

 

[mercedes98]

Where would I insert that into the original formula?

 

[Special-K99]

Instead of the original formula

 

[FormR]

@ Special-K99 - I think you have a mis-placed paren:

=SUMPRODUCT((E31:K31="V")*(E32:K32))

@ mercedes98 - here is another option:

=SUMIF(E31:K31,"V",E32:K32)