If I understand what you are trying to do, I think the SUMIF function is
what you will want to use. Assuming Column A has your strings to be searched
and Column B has your numbers to be summed (just change the ranges as
required; you can specify a larger range than your current data set if you
will adding new data in the future)...

=SUMIF(A1:A1000,"Some string value",B1:B1000)

--
Rick (MVP - Excel)


"BG Mark" wrote in message
...
How can I use the Find function within an array formula to check a column
to
locate evey occurence of a string and subsequently sum the corresponding
numbers in a different column