+ Reply to Thread
Results 1 to 2 of 2

Large condition with sumproduct & MMULT

  1. 11-27-2020, 09:59 AM #1
    RAMESHB
    RAMESHB is offline
    Registered User
    Join Date
    01-30-2019
    Location
    Hyderabad
    MS-Off Ver
    2010
    Posts
    18

    Large condition with sumproduct & MMULT

    Hi

    Here i am attached a file once look it

    Here i am Required total value based on condition
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-27-2020, 10:03 AM #2
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,794

    Re: Large condition with sumproduct & MMULT

    You forgot to fill in (manually) the results you'd expect to see with your sample data. You also forgot to explain what you are trying to do in your post - nobody should have to open a workbook to find out!
    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
+ 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] large function with condition
    By manik68 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2020, 06:44 AM
  2. LARGE( IF( AND( condition A; condition B);Array);rank)
    By Jambon95 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-09-2019, 11:24 AM
  3. [SOLVED] Sumproduct and Large formula with condition.. Required Help..
    By kundanlal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-13-2016, 03:30 AM
  4. [SOLVED] How to combine LARGE and SUMPRODUCT
    By Phillycheese5 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-09-2016, 11:07 PM
  5. Breakup of MMULT-Transpose function with addition of condition in existing formula
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-24-2013, 06:57 AM
  6. Lookup or Sumproduct or if condition with sumproduct and vlookup
    By angie.chang in forum Excel General
    Replies: 1
    Last Post: 05-19-2012, 02:54 AM
  7. PCA or MMULT on large array
    By lady_Jane in forum Excel General
    Replies: 4
    Last Post: 06-17-2011, 02: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1