I have on one sheet a value in B2, that i want to find on another sheet in A
column and i want to sum all the values in the corresponding row.

Any help would be great, Thanks in advance.