How can I count the number of comma separated numbers in a google spreadsheet?
Just so it is not missed when counting non-numeric items (thanks @noway and @wchiquito as count did not work for my text)
=COUNTA(SPLIT(A1,","))
One option is to use the following formula:
=COUNT(SPLIT(A1; ","))
Here's an example: