Another interp
In Sheet1's C2:
=SUMPRODUCT((Sheet2!$A$2:$A$100=B2)*Sheet2!$B$2:$I V$100)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"KimC" wrote:
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.