Good idea. Let them find out the answers themselves. I know that RTFM is
hard but someone has to do it! :)

Tyro

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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!!!