Lookup & Sum the corresponding row

[KimC]

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.

 

[Max]

One interp ..

In Sheet1,
maybe you meant to do something like this in say, C2:
=SUMIF(Sheet2!A:A,B2,Sheet2!E:E)
which assumes the sum range is col E in Sheet2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik

 

[Max]

Another interp
In Sheet1's C2:
=SUMPRODUCT((Sheet2!$A$2:$A$100=B2)*Sheet2!$B$2:$IV$100)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik