+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Adding values in column based on criteria from another column

  1. #1
    Registered User
    Join Date
    10-07-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    56

    Question Adding values in column based on criteria from another column

    Example:

    Column A: date
    Column B: Type of purchase (bills, food, gas, etc)-from dropdown
    Column C: Amount of purchase

    Ideal setup:

    Column D: list different types of purchases [no duplicates] (bills, food, gas, etc)
    Column E: sum the amount of all purchases of that type (bills-from column D- : $1500.80, etc)

    Is this possible to set up with one formula? Or do I have to use VBA? Multiple columns? Yeah, I've been racking my brain on this one, trying to figure out ways to do what I need.

    Also note: will have to repeat the process for sub-types, as well. (Fast Food & Utilities, to continue with the above example).

    Many thanks, in advance, for any kind of input people here have.
    Last edited by Apelcius; 01-10-2012 at 10:43 PM. Reason: Answered
    --Apelcius--
    Learn. Share. Rinse, Repeat.

  2. #2
    Registered User
    Join Date
    10-07-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Adding values in column based on criteria from another column

    For further clerification on what I'm looking for, I've attached a spreadsheet with the above example.

    Essentially, the list will keep going, as the year continues. So, I will need to be able to count the number of purchases of each type/sub-type. Then, will need to add those associated values.

    If this doesn't make sense, please say so, and I'll try and answer any questions about it that I can, or clerify another way.
    Attached Files Attached Files

  3. #3
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Adding values in column based on criteria from another column

    Apelcius,

    It looks to me like all you need is the SumIf() formula.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    10-07-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2010
    Posts
    56

    Thumbs up Re: Adding values in column based on criteria from another column

    Awesome! Thanks! Exactly what I was looking for.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1