+ Reply to Thread
Results 1 to 5 of 5

Sumif Formula With 2 Condition in Horizontal & Vertical

  1. #1
    Registered User
    Join Date
    04-27-2015
    Location
    Haridwar
    MS-Off Ver
    2007
    Posts
    2

    Question Sumif Formula With 2 Condition in Horizontal & Vertical

    Hi,

    Is there any to use sumif with 2 condition as horizontal & Vertical

    Jan Feb Mar
    A 1 2 3
    B 5 10 15
    C 4 8 12
    B 1 2 3

    Jan
    B =

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,282

    Re: Sumif Formula With 2 Condition in Horizontal & Vertical

    Try
    =SUMPRODUCT((B2:D5)*(B1:D1=A7)*(A2:A5=A8))
    or
    =SUMIF(A2:A5,A8,INDEX(B2:D5,,MATCH(A7,B1:D1,0)))
    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,958

    Re: Sumif Formula With 2 Condition in Horizontal & Vertical

    Use SUMPRODUCT. see file.
    Attached Files Attached Files
    Glenn



  4. #4
    Registered User
    Join Date
    04-27-2015
    Location
    Haridwar
    MS-Off Ver
    2007
    Posts
    2

    Re: Sumif Formula With 2 Condition in Horizontal & Vertical

    Thanks to all

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,958

    Re: Sumif Formula With 2 Condition in Horizontal & Vertical

    Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula Horizontal and Vertical Result excel
    By almourasel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2015, 09:15 PM
  2. Formula to sum with two criteria joint horizontal vertical
    By felixpanganiban in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2013, 03:52 AM
  3. What formula, horizontal and vertical
    By djfatboyfats in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-28-2008, 08:06 PM
  4. Replies: 1
    Last Post: 07-29-2008, 10:50 AM
  5. Horizontal Vs. Vertical + Nested formula problems
    By alnoor in forum Excel General
    Replies: 9
    Last Post: 01-27-2008, 01:06 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