+ Reply to Thread
Results 1 to 4 of 4

Sumifs with multiple criterias

  1. #1
    Forum Contributor
    Join Date
    07-21-2010
    Location
    Alta, Norway
    MS-Off Ver
    Excel 2003
    Posts
    119

    Sumifs with multiple criterias

    Hi all!

    Once again I find my excel skills not sufficient and I seek my luck here
    I have attatched a sample spreadsheet.

    Basically I am trying to write a formula with three criterias. These are (ref spreadsheet):
    1. Month (found in column A in "Returns!")
    2. Year (found in column B in "Returns!")
    3. Name (Found in row 3 in "Returns!")

    I would really appreciate any help

    Gnoke
    (please ask if my explenation was no good)
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Sumifs with multiple criterias

    Here you go. Did it help?
    Attached Files Attached Files
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Sumifs with multiple criterias

    Use this ARRAY formula

    =INDEX(Returns!$A$1:$W$500,MATCH(1,($A4=Returns!$A$1:$A$500)*(B$1=Returns!$B$1:$B$500),0),MATCH(B$2,Returns!$1:$1,0))

  4. #4
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Sumifs with multiple criterias

    Perhaps an array formula can help, see the attachment

    Array formula should be saved with Shift+Control+Enter
    Attached Files Attached Files
    regards

    johnjohns

    When you are not sure where to go, every road takes you there!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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