Lookup & Sum the corresponding row

K

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.
 
M

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
 
Top