+ Reply to Thread
Results 1 to 3 of 3

Find values via multi-cell array formula with multiple criteria

  1. #1
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    271

    Find values via multi-cell array formula with multiple criteria

    Good day,

    How could I find all values at once via one multi-cell array formula (one for all cells)?
    I can simply enter non-array formula smth like this one:
    HTML Code: 
    and find all values one by one, but can't do the same with all selected cells.
    Attached Files Attached Files
    Last edited by T.I.; 01-23-2021 at 03:34 PM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: Find values via multi-cell array formula with multiple criteria

    Please try

    =SUMIFS(B2:F6,A2:E6,I2:I5)

    or
    =SUMIFS(B2:F6,A2:E6,I2)
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-05-2018
    Location
    Tbilisi, Georgia
    MS-Off Ver
    2013, 2016
    Posts
    271

    Re: Find values via multi-cell array formula with multiple criteria

    So simple... I should have guessed!
    Thank you so much, Bo_Ry

+ 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. [SOLVED] Array formula to return list of values that match multiple criteria
    By TFiske in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-30-2016, 01:57 PM
  2. [SOLVED] Regular formula or array for multi colum multi criteria?
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2016, 01:40 PM
  3. [SOLVED] Find a date with multiple criteria without using an array formula
    By nikos_tsagos in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-08-2015, 09:46 AM
  4. Array formula to return multiple values based on various (OR) criteria
    By dancing-shadow in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2013, 05:12 AM
  5. [SOLVED] Find minimum (ignoring blank cell or zero values) with Multiple Criteria
    By Joeywei in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-27-2013, 08:45 PM
  6. Sum if array formula, with multi criteria, some in the same column
    By carlosmaldonado in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2012, 04:30 AM
  7. Multi Criteria combo box returning array values
    By robcosta in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-24-2008, 10:41 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1