Forum Discussion

jukhk06's avatar
jukhk06
Copper Contributor
May 20, 2022
Solved

How to sum the total for 1(1A) + 3(3A) + 5 = 9(4A) ?

How to sum the total for 1(1A) + 3(3A) + 5 = 9(4A) ?

Other examples:

1(1A) + 3(2A) = 4(3A)

10(2A) + 1 = 11(2A)

I need to sum at least 100 cells in the Excel (same column or same row). Thank you.

excel
Formulas and Functions
training
  • SergeiBaklan's avatar
    SergeiBaklan
    May 20, 2022

    jukhk06 

    Here formula could work

    =SUM(--IFERROR(LEFT(C2:C4, FIND("(",C2:C4)-1 ), C2:C4) ) & "(" &
  SUM(--IFERROR(MID(C2:C4, FIND("(",C2:C4)+1, FIND("A",C2:C4)-FIND("(",C2:C4)-1 ), 0)) &
  "A)"
    • jukhk06's avatar
      jukhk06
      Copper Contributor
      May 20, 2022

      Lorenzo Many thanks for your swift response. The results are exactly what I want. May I know if there is any reference link that I can learn the  Power Query ? I seem not see any formula in the cell. Thank you very much for your patience and advice 🙂

Resources