Forum Discussion

DonYTechGuy's avatar
DonYTechGuy
Copper Contributor
Feb 27, 2020
Solved

Adding 2 numbers in a column with a comma in between

This formula works to count more than one number in a cell separated by a comma in Google Sheets.  =COUNTA(SPLIT(JOIN(",",L10:L142),",")) 1,2 3,4,5   See the Screenshot below.   Is there an eq...
excel
Formulas and Functions
  • PReagan's avatar
    PReagan
    Feb 27, 2020

    Hello DonYTechGuy,

     

    As a variant:

    =SUM(SUMPRODUCT(LEN(Cell_Range)),-SUMPRODUCT(LEN(SUBSTITUTE(Cell_Range,",",""))),COUNTA(Cell_Range))
Savia's avatar
Savia
Iron Contributor
Feb 27, 2020
Only if you install a small user-defined function like so: Function Eval(Ref As String) Application.Volatile Eval = Evaluate(Ref) End Function Then you can do: =eval(SUBSTITUTE(cell reference,",","+"))
Savia's avatar
Savia
Iron Contributor
Feb 27, 2020
I realised I misread your problem - ignore this.

Resources