Results 1 to 4 of 4

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

Threaded View

  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.

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