Formulas!

[Els]

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!!!

 

[David Biddulph]

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

 

[Pete_UK]

I suggest you put the word TEST in D1 (so that you can put other words
in there to get other totals) and this formula in E1:

=SUMIF(A$1:A$50,D1,B$1:B$50)

Copy it down if you want to put other text values down column D.

Hope this helps.

Pete

 

[Sandy Mann]

=SUMIF(A1:A50,"Test",B1:B50)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Tyro]

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

Tyro