+ Reply to Thread
Results 1 to 5 of 5

Sumifs for horizontal and vertical criteria

  1. 06-09-2020, 04:35 PM #1
    jackson_hollon
    jackson_hollon is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    Sumifs for horizontal and vertical criteria

    Hello,

    Hope you have a great day.

    I am trying to solve an issue with sumifs for horizontal and vertical criteria. I have attached a file here. From cell A1 to G6, are the data I got. From I2 to L17 is the outcome I need. I have 2 horizontal criteria from column A and column B, and one vertical criteria on Row 1.

    Test.PNG

    Thanks a lot.
    Attached Files Attached Files
    Last edited by jackson_hollon; 06-09-2020 at 04:56 PM.
    Reply With QuoteRegister To Reply
  2. 06-09-2020, 04:49 PM #2
    CARACALLA
    CARACALLA is offline
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,800

    Re: Sumifs for horizontal and vertical criteria

    L2=if($i2<>"",sumproduct(($a$2:$a$6=$i2)*($b$2:$b$6=$j2)*($c$1:$f$1=$k2)*($c$2:$f$6)),"")
    Last edited by CARACALLA; 06-09-2020 at 04:59 PM.
    Reply With QuoteRegister To Reply
  3. 06-09-2020, 04:51 PM #3
    jackson_hollon
    jackson_hollon is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    Re: Sumifs for horizontal and vertical criteria

    CARACALLA,

    Perfect. This is what I need. Thanks a lot.

    Jackson
    Reply With QuoteRegister To Reply
  4. 06-09-2020, 05:12 PM #4
    CARACALLA
    CARACALLA is offline
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,800

    Re: Sumifs for horizontal and vertical criteria

    You are welcome
    Reply With QuoteRegister To Reply
  5. 06-09-2020, 05:21 PM #5
    jackson_hollon
    jackson_hollon is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    Re: Sumifs for horizontal and vertical criteria

    CARACALLA,

    Is there a way I can use a formula to get the data from 2 different tabs?
    https://www.excelforum.com/excel-for...rent-tabs.html
    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] SumIfs / Sumproduct for table with vertical and horizontal lookup criteria (text+dates)
    By benvass in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2018, 10:34 AM
  2. Sumifs horizontal vertical
    By Play1234 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-26-2017, 04:31 PM
  3. [SOLVED] SUMIFS(?) I need to sum data using both horizontal and vertical criteria
    By bighandsam in forum Excel General
    Replies: 22
    Last Post: 01-06-2017, 11:31 PM
  4. Sumifs for vertical & horizontal condition
    By rchure in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2016, 12:34 AM
  5. SUMIFS with vertical criteria and horizontal criteria (horiz. crit. is a date range check)
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2016, 03:39 AM
  6. solved
    By ravidesai in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-18-2016, 10:55 AM
  7. For dynamic table and chart: how to sumifs with horizontal and vertical multiple criteria
    By gabs1972 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-06-2013, 05:12 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1