+ Reply to Thread
Results 1 to 2 of 2

how to make formula to sum with multiple criteria considering horizontal and vertical way

  1. 05-21-2019, 02:33 AM #1
    felixpanganiban
    felixpanganiban is offline
    Registered User
    Join Date
    10-02-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    86

    how to make formula to sum with multiple criteria considering horizontal and vertical way

    friends,

    please help us to make formula to sum with multiple criteria considering horizontal and vertical way.

    see attached.
    Attached Files Attached Files
    👍
    Reply With QuoteRegister To Reply
  2. 05-21-2019, 02:42 AM #2
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: how to make formula to sum with multiple criteria considering horizontal and vertical

    Put this on K5 and copied as necessary

    =SUMPRODUCT(($B$5:$B$9=$J5)*($D$4:$H$4=$K$4)*($D$5:$H$9))
    Attached Files Attached Files
    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. Choose data horizontal and vertical, multiple criteria
    By snakebite93 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-16-2018, 03:38 AM
  2. Horizontal and vertical criteria ranges + vlookup multiple conditions?
    By lukasvjohansson in forum Excel General
    Replies: 9
    Last Post: 07-16-2017, 01:59 PM
  3. solved
    By ravidesai in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-18-2016, 10:55 AM
  4. Sum with multiple criteria Horizontal and Vertical
    By freqzz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2015, 04:39 AM
  5. Sum Multiple Criteria horizontal and vertical
    By baronk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-16-2015, 07:55 AM
  6. look up with multiple vertical & horizontal criteria and find closest approximation
    By apn3a in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2015, 10:33 AM
  7. [SOLVED] Matching multiple criteria in two books, one data is horizontal, the other is vertical.
    By udrmichelle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2015, 04:58 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