Results 1 to 12 of 12

Can we use Index/match to return Sumrange for Sumif?

Threaded View

  1. 03-20-2024, 11:57 AM #1
    FT00
    FT00 is offline
    Forum Contributor
    Join Date
    10-02-2023
    Location
    Singapore
    MS-Off Ver
    Microsoft 365
    Posts
    184

    Can we use Index/match to return Sumrange for Sumif?

    Hi, i need to sumif by column and row criteria, i know this can be achieve by using Sumproduct.

    However, i wish to know if its possible to Return the Sumrange column using Index/Match so that i can use Sumif instead.

    I am not a fan of Sumproduct....
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. SumIF in a single horizontal row (range and sumrange in same row)
    By noclueaboutexcel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-14-2018, 12:32 AM
  2. Need help today please! Sumif, index, index match
    By helpmeplz_ in forum Excel General
    Replies: 2
    Last Post: 08-26-2017, 12:50 PM
  3. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  4. SumIf with sumrange in multiple variable columns
    By rpinxt in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-19-2015, 09:10 AM
  5. SUMIF, Index and Match Formula. Return Cell value
    By FLani in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2014, 02:43 AM
  6. 2010 - Need to match data and return specific cell value - SUMIF? MATCH? INDEX? HELP!
    By AJev in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2013, 02:10 PM
  7. How to sumif with multiple range and single sumrange
    By helpplease! in forum Excel General
    Replies: 4
    Last Post: 11-05-2007, 11:53 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