Question:

Help with Excel functions?

by  |  earlier

0 LIKES UnLike

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?

 Tags:

   Report

2 ANSWERS


  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


  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.

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Unanswered Questions