Forum Discussion
Solved
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.
Many thanks in advance,
best wishes,
Niklas
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/m-p/41382/highlight/true#M235
and that is G&T approach https://techcommunity.microsoft.com/t5/Get-and-Transform-Data/Get-amp-Transform-solving-all-sorts-of-Excel-issues/m-p/46208/highlight/true#M40
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/m-p/41382/highlight/true#M235
and that is G&T approach https://techcommunity.microsoft.com/t5/Get-and-Transform-Data/Get-amp-Transform-solving-all-sorts-of-Excel-issues/m-p/46208/highlight/true#M40