Forum Discussion

Anthonyinnz's avatar
Anthonyinnz
Copper Contributor
Apr 26, 2022
Solved

Sum values if cell contains text that isin my source cell (Vlookup cell contains a smultiple values)

Greetings Can someone please help me with the following simplified example. I have a spreadsheet containing Code  Amount 101     $10 101     $20 102     $10 103     $20   I want a formulae t...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Apr 27, 2022

    Hi Anthonyinnz 

     

     

    in E3:

    =SUM( ISNUMBER(SEARCH(Table1[Code],[@Codes])) * Table1[Amount] )

    AND validate it with [Ctrl]+[Shift]+[Enter] (or equiv. on Mac) if you don't run Excel 2021 or 365

Lorenzo's avatar
Lorenzo
Silver Contributor
Apr 27, 2022

Hi Anthonyinnz 

 

 

in E3:

=SUM( ISNUMBER(SEARCH(Table1[Code],[@Codes])) * Table1[Amount] )

AND validate it with [Ctrl]+[Shift]+[Enter] (or equiv. on Mac) if you don't run Excel 2021 or 365

  • Anthonyinnz's avatar
    Anthonyinnz
    Copper Contributor
    Apr 27, 2022
    Excellent - Thank You
    I tried using several different functions without success ... didnt think of the above :o)
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Apr 28, 2022
      Glad I could help Anthonyinnz & Thanks for posting back

Resources