Results 1 to 26 of 26

SUMIF with multiple column and row criteria

Threaded View

  1. #10
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: SUMIF with multiple column and row criteria

    Hi, Adam



    As FDibbinss suggest "For qtr and year, it would probably be easier if you used read dates instead of just years and names...1/1/14, 2/1/14 etc ".

    I make a little adjusment for you.

    See the attachment.
    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. [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