Help with Excel functions?

Question

Is there a function that I can use for the following:

Column A has a numerical amount

Column B has text identification

Is there a function that I can do that will add together all of the numbers from column A that have matching column B text?

What I have is a series of account balances from several different accounts with the expenditure in "A" and the name of the account in "B."" Instead of going through and manually picking them out, is there a way for the function to pick them out for me?

Answer 1

you want to use the sumif() function

if

B1=AC1

B2=AC2

B3=AC1

B4=AC3

and you wanted to add up all the AC1 with amounts to the left of AC1 in column A

then

=SUMIF(B$1:B$4,"AC1",A$1:A$4)

just adjust your range to fit

Answer 2

The quickest solution is to select the data dropdown menu and select filter then auto filter.  This will place an arrow in the heading for your columns. the select the dropdown on you text column and you can see the data filtere to you requirements.