+ Reply to Thread
Results 1 to 6 of 6

Sumifs Functions Columns and rows

  1. 07-02-2018, 12:55 AM #1
    hudson andrew
    hudson andrew is offline
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    354

    Sumifs Functions Columns and rows

    Hi all,

    Can someone please help me how do sum if my critera is in "columns" and I wanted to sum below table for the months range of Jan till June using a formulas for Hudson.

    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Daniel 13 8 8 8 10 10 14 13 12 11 5 3
    Samuel 16 14 18 21 24 29 31 33 35 31 17 12
    Andrw 16 10 11 12 15 18 32 33 31 32 14 9
    Hudson 22 13 16 17 21 25 38 43 40 43 20 13
    Reply With QuoteRegister To Reply
  2. 07-02-2018, 12:56 AM #2
    kersplash
    kersplash is offline
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Sumifs Functions Columns and rows

    Can you attach a sample workbook as it's difficult to write something for what you've provided.
    Reply With QuoteRegister To Reply
  3. 07-02-2018, 01:04 AM #3
    hudson andrew
    hudson andrew is offline
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    354

    Re: Sumifs Functions Columns and rows

    Hello friend ,

    sorry this is office machine and I can not upload a file

    asume I want the formula in sheet 1 cell N2

    for Hudson I want the sumifs s for the month range Jan till June
    Reply With QuoteRegister To Reply
  4. 07-02-2018, 01:36 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,390

    Re: Sumifs Functions Columns and rows

    Here's one way:

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    1
    		 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    2
    		 Daniel
    13
    8
    8
    8
    10
    10
    14
    13
    12
    11
    5
    3
    3
    		 Samuel
    16
    14
    18
    21
    24
    29
    31
    33
    35
    31
    17
    12
    4
    		 Andrw
    16
    10
    11
    12
    15
    18
    32
    33
    31
    32
    14
    9
    5
    		 Hudson
    22
    13
    16
    17
    21
    25
    38
    43
    40
    43
    20
    13
    6
    7
    8
    		 Start: Jan
    9
    		 Finish: Jun
    10
    		 Hudson
    114
    Sheet: Sheet1

    Excel 2016 (Windows) 32 bit
    C
    10
    =SUM(INDEX($B$2:$M$5,MATCH(B10,A2:A5,0),MATCH(C8,$B$1:$M$1,0)):INDEX($B$2:$M$5,MATCH(B10,A2:A5,0),MATCH(C9,$B$1:$M$1,0)))
    Sheet: Sheet1
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 07-03-2018, 03:15 AM #5
    hudson andrew
    hudson andrew is offline
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    354

    Re: Sumifs Functions Columns and rows

    It worked like magic and thanks a lot
    Reply With QuoteRegister To Reply
  6. 07-03-2018, 03:59 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,390

    Re: Sumifs Functions Columns and rows

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula required for SUMIFS with two criteria over multiple columns and rows
    By TallAussie in forum Excel General
    Replies: 4
    Last Post: 06-14-2017, 01:51 AM
  2. [SOLVED] Sumifs with 3 Criteria Mixed with Rows and Columns
    By mbshafe in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-06-2016, 12:07 PM
  3. [SOLVED] Sumifs across columns and rows
    By Cressie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-21-2015, 05:41 AM
  4. How to do sumifs from cells on the same worksheet and ranges by rows instead of columns?
    By Brookshire in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 06:09 PM
  5. [SOLVED] SUMIFS and multiple parameters across rows and columns
    By george_k in forum Excel General
    Replies: 4
    Last Post: 11-02-2012, 02:56 PM
  6. SUMIFS - including both columns and rows ?
    By sirkusjon in forum Excel General
    Replies: 2
    Last Post: 12-09-2011, 04:57 PM
  7. AVERAGEIFS, SUMIFS and COUNTIFS Functions New functions in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-15-2007, 05:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1