Forum Discussion

Rob__13's avatar
Rob__13
Copper Contributor
May 03, 2023
Solved

Formula which includes all results matching multiple criteria (no spilling)

Hi All,   I'm looking for a formula which can search a column and pull out all the relevant values based on 2 criteria, collating them all into one cell.  I have tried the following: - Lookup - on...
  • OliverScheurich's avatar
    May 03, 2023

    Rob__13 

    =SUMPRODUCT(($A$12:$A$28=A3)*($B$12:$B$28=B3)*$C$12:$C$28)

    You can try this formula.

     

Resources