Glad we could help you.

JLatham's solution is easier and more elegant.
You do need to learn about PIVOT tables... it will save you lot of grief.
Try to master VLOOKUP also.



"Vercingetorix.I" wrote:

Thank you, I am going over this site and it is great, I didnt expect to get
an answer so quickly either...

"Vercingetorix.I" wrote:

I need a formula to search for names in columns and then add the figures that
are in a different column, so for example i have names in one column and then
need to find each name and add the dollar amounts that are listed in another
column...