Forum Discussion

Noel Robles's avatar
Noel Robles
Copper Contributor
Jul 23, 2018

Help with formula that sums first digit if the string contains certain characters.

Hello community, I'm trying to make a formula that does this specifically.   Example data Amount - Item Code and Name (COLUMN B, ROWS 97 TO 103)   1 - (151) item 01 3 - (157) item 02 10 - (001...
excel
Formula help
Formulas and Functions
Macros and VBA
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 23, 2018

Hi Noel,

 

That could be array formula (Ctrl+Shift+Enter)

=SUM(IF(ISNUMBER(SEARCH("(151)",B97:B103)),VALUE(LEFT(B97:B103,2)),0))
  • Noel Robles's avatar
    Noel Robles
    Copper Contributor
    Jul 24, 2018

    Duuuuuuuddddeeeee that was perfect!

    Thanks a lot! You made my day and saved us hours of work.

Resources