You want to SUM the numbers IF the rows meet a particular criterion, so try
typing SUMIF into Excel help.
--
David Biddulph

"Els" wrote in message
...
Sorry guys if this seem basic but I am stuggling to find the right formula
for what I want Excel to do.

I have 2 columns of data, Column A has text and Column B is numeric. In a
separate field I just want a formula which can SUM up all the values in
column B which correspond to a particular entry in column A.

e.g. In 50 line of data the word TEST may appear 10 times in column A. The
corresponding entry in column B related to the word TEST may have
different
values. I just want to find the sum of the related values.

Hope this makes sense, and apologies again if I couldn't see the wood for
the trees and it ends up being a basic answer!!!