SOLVED

# sum Function

Copper Contributor

# sum Function

Hello everybody,

I would like to count the amount of numerics (1-10) in a row, count it without commas,

but I have to take into account

that in one cell is more than one number like

1,2,4,7,9

8,9,4,2

2,3,10

the range of numerics is 1 - 10 where 10 shoud be counted as ONE numeric like

the others:

The result here would be:

1,2,4,7,9

8,9,4,2

2,3,10

Result: 12

I have counted the AMOUNT OF numbers WITHOUT COMMAS and the 10 like ONE number,

finally SUM it up: result -->12.

I have already tried it with several commands like "sum" and "length" etc.  but unfortunately

I was not succesful.

I hope that some will find the time to suggest a solution to solve this  problem.

best wishes,
Niklas

best response confirmed by Niklas Kalz (Copper Contributor)
Solution

# Re: sum Function

Hi Niklas,

Better to republish your question on Excel community here in Formulas & Functions space.

Anyway, simular question was discussed here, the only number numbers are separated by Alt+Enter, not comma. Here is about formulas https://techcommunity.microsoft.com/t5/Excel/Calculate-simple-equation-which-is-included-in-one-cell...

1 best response

Accepted Solutions
best response confirmed by Niklas Kalz (Copper Contributor)
Solution

# Re: sum Function

Hi Niklas,

Better to republish your question on Excel community here in Formulas & Functions space.

Anyway, simular question was discussed here, the only number numbers are separated by Alt+Enter, not comma. Here is about formulas https://techcommunity.microsoft.com/t5/Excel/Calculate-simple-equation-which-is-included-in-one-cell...