Results 1 to 8 of 8

Thread: Sumif On Multiple Columns Using Multiple Criteria By Passing A Range Of Values

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-14-2013, 10:49 PM #1
    Luke M
    Luke M is offline
    Junior Member
    Join Date
    May 2013
    Posts
    3
    Rep Power
    0

    Sumif On Multiple Columns Using Multiple Criteria By Passing A Range Of Values

    I am looking for a formula (or macro) that can return the aggregate a range of numbers for a country, having taken account of multiple criteria for multiple columns.

    Please see .xlsx for example.


    This seems to be a simple problem but has even eluded professional modellers at work!

    Any help would be much appreciated!
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Of A Row of Cells In Multiple Columns Based On Criteria And Column Index
    By excel_learner in forum Excel Help
    Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  2. Sum values based on multiple criteria
    By Jorrg1 in forum Excel Help
    Replies: 8
    Last Post: 01-07-2013, 03:04 PM
  3. SUMIF With Multiple Criteria In The Same Column Criteria Range
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 08-11-2012, 10:50 PM
  4. Sum values based on multiple criteria
    By vmath in forum Excel Help
    Replies: 1
    Last Post: 05-07-2012, 08:53 AM
  5. Fetch multiple values based on criteria
    By Lucero in forum Excel Help
    Replies: 8
    Last Post: 04-07-2012, 12:35 PM

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
  •  

Forum Rules