Hi,

Does anyone know of a formula which would basically do the same as a
lookup but it instead of showing the amount that corresponds with the
name, it would find every occurrence of that name and add up all the
values in to a single cell? I've been looking for several hours and
tried different things (sumif, lookup, vlookup etc.) but have not found
the one that works.

I'd appreciate it if someone could put me out of my misery!

Thanks.:)


--
h0l1yw0od
------------------------------------------------------------------------
h0l1yw0od's Profile: http://www.excelforum.com/member.php...o&userid=28989
View this thread: http://www.excelforum.com/showthread...hreadid=505332