Results 1 to 5 of 5

Using INDEX and MATCH to find SUM

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2021
    Location
    Here
    MS-Off Ver
    365
    Posts
    2

    Post Using INDEX and MATCH to find SUM

    Hi all. Hope you're doing well.

    I'm looking to find out how to use INDEX and MATCH in a way that will sum all the values in Column 2 IF the value in column 1 is equal to the value in cell R2C5. Column 1 will contain duplicate values, but it's corresponding value in Column 2 may vary. e.g. Column 1 contains the name of a county, column 2 contains the count of a specific building in that county. My formula wants to be able to figure out how many overall buildings there are.

    With so many types of building (warehouse, store, residence, utility etc.) the whole array is very large and wanted a quick way to get the sum, if this is possible.

    (numbers have been generated using RANDBTEWEEN 2,999 ;-))

    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use INDEX MATCH to find all values that match the exact same criteria
    By Clooney003 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-24-2021, 03:08 PM
  2. Index Match to find match date to a range of dates
    By downcrusher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 06:05 PM
  3. Replies: 5
    Last Post: 02-26-2017, 04:46 PM
  4. [SOLVED] Formula to find 2nd Match using Index and 2 Match conditions
    By Cra5h in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-24-2016, 11:52 AM
  5. [SOLVED] index-match where match needs to find substring
    By Machtyn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2012, 11:33 AM
  6. Replies: 5
    Last Post: 02-29-2012, 08:51 PM
  7. [SOLVED] INDEX, FIND.... MATCH????
    By Sonya in forum Excel General
    Replies: 3
    Last Post: 10-27-2005, 04:05 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