Hi there,
I've been having some trouble with the following..
I have something like:
columns A B (sheet1)
u 2
v 1
w 5
x 3
y 1
z 2
and in a seperate sheet:
column D (sheet2)
w
z
u
I would like to get a sum of the values in sheet1!B:B that correspond to the values in sheet2!D:D (where only those in sheet1!A:A that match sheet2!D:D are sumed). In the above example I would like to get = 9.
I had read that using something like the following would work but I just get the "#VALUE!" error...
Formula:Please Login or Register to view this content.
Does it matter that my actual sheet1!A:A and sheet2!D:D look more like "xyz, abc"?
Thanks for your help,
Geoff.
Bookmarks