#### mercedes98

##### New Member

- Joined
- Jun 4, 2015

- Messages
- 6

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.

Someone suggested using this formula but I don't know how to fit it into my original formula =SUMPRODUCT((E31:K31)="V"*(E32:K32))

I am on a deadline and need to get this solved as soon as possible. I would appreciate any help at all. Thank you so much