Results 1 to 26 of 26

SUMIF with multiple column and row criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-01-2008
    Location
    Perth, Australia
    MS-Off Ver
    Excel 365
    Posts
    135

    Smile SUMIF with multiple column and row criteria

    Hi All,

    I am looking for some help with a formula for the attached spreadsheet's summary Tab (G5:K6).

    Demo1.xlsx

    The formula needs to be able to read from the Data Tab and:

    1. Total the values in a column based on the country being selected and then multiple expense types being selected by dropdown (up to 3). Formula in G9 does part of this (via help on the forum yesterday).
    2. By changing the year and Month in rows 2 and 3 the summary table should update accordingly.

    I am trying not to use named ranges for the columns and think a sumif/index/match formula may be the way to go but I have tried so many different things that are not working I think my head is about to pop.

    Any help is greatly appreciated.

    Thanks,

    Adam
    Last edited by Zimbo; 03-11-2015 at 11:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiple Criteria SUMIF Using Column as Negative Criteria
    By freybe06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2014, 04:46 PM
  2. SUMIF for multiple column/sheet criteria
    By preddy1110 in forum Excel General
    Replies: 1
    Last Post: 04-13-2012, 11:45 AM
  3. Replies: 2
    Last Post: 01-27-2012, 01:32 PM
  4. Multiple Sumif (Criteria within same column)
    By Thanksinadvance in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-20-2011, 09:35 AM
  5. SumIF multiple column criteria
    By gd19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2008, 05:56 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1