I'm not sure If I could explain this easy but let me try


on sheet1 there are name list
on sheet2 there are list of names with their earning in $(Name could appear
more than once)
on sheet3 I want to find all cells that contains (David) in sheet2 & what
ever $
that's next to it add it when I click a command button

If this doesn't explain enough maybe I could attach the sample let me know
Thanks !!!!

Maybe you could acheive the same effect easily with the use of
auto-filters on sheet2?


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=541744

this could work

=SUMIF(A1:B6,C1,B1:B6)
A1:B6 is the total range
C1 is the criteria
B1:B6 is the numbers to add


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=541744