Forum Discussion
Solved
Counting numbers in a column
Hello together! How is it possible to count the amount of numbers in a column: The column of numbers look like this: 1,2 3,4 3,5 5 9 6 But: THE COMMAS in each row should NOT be counted, o...
Hi,
This is the formula that you need:
=SUMPRODUCT(LEN(SUBSTITUTE(A1:A6,",","")))
Hi,
This is the formula that you need:
=SUMPRODUCT(LEN(SUBSTITUTE(A1:A6,",","")))
Many thanks, this was the best answer!!