Hello,
I've been trying to get the following formula:

Get the total of ALL Misc (K16, K17, K27, K37) of the table H3-U59 and put the total in (Cell F50).

I added a picture for easier understanding. Ive been trying with VLookup, sumif..

Thanks for any help in advance
Nan

PS : the ( ) means its a negative amount