Results 1 to 3 of 3

Thread: Sum values based upon multiple sets of criteria

  1. #1

    Sum values based upon multiple sets of criteria

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Here is my situation:

    I have a spreadsheet that contains almost 5,000 rows and need a formula or someway fo make it easier to format. I am currently working in excel 2007 but do have access to 2010.

    Column A: Dates
    Column B: Dollar Amount
    Column C: Name
    Column F: Number

    I want to total the values in column F based on if the Column A values are the same AND if the values in Column B are the same AND if the values in Column C are the same.

    It would also be great if I could automatically get excel to insert a blank row in between each total so that the spreadsheet is easier to view.

    Any help would be greatly appreciated. I don't know where to start.


  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    If it is sorted, look at Data>Subtotals.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    Not quite sure if I replicated your data correctly, but take a look at this...

    If I'm off base, maybe attach a workbook with some sample data of what you have, and what you'd like to see. (Click "Go Advanced" at the bottom right to upload a workbook)
    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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