Results 1 to 6 of 6

Sum from multiple columns based on multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2017
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Sum from multiple columns based on multiple criteria

    I'm trying to sum multiple columns together based on criteria. The first criteria is the names have to match and the second criteria times have to match. I cant use a helper column because this data will change regularly both the numbers and the names will change.
    I've tried index and match and sumproduct and I can't get either of them to work with this, Although I'm not really familiar with sumproduct so I may just not know how to do it but the last formula I tried was =SUM(IF(AND($E$29=E27,$A$30=$A$2:$A$25),B2:T26)) and it does not work at all. any help you could give would be great!

    Thanks,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-09-2017, 05:55 PM
  2. Average numbers from multiple columns based on multiple criteria
    By abambi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2015, 01:52 PM
  3. Populating fields in multiple cells based on criteria in multiple columns
    By excelalways in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2014, 08:17 AM
  4. formulas for search based on multiple criteria in multiple columns
    By oneworld in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2013, 06:57 AM
  5. [SOLVED] Deleting Duplicates Based on Multiple Criteria from Multiple Columns
    By Franklic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 05:31 PM
  6. Sum data based on multiple criteria across multiple columns
    By lbn7153 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2012, 07:18 AM
  7. Macro to Segregate the data based on Multiple Criteria's in Multiple Columns -Challenging!
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2012, 07:31 AM

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