Menu
I've got a cell which has values 1,2,3,4
I need a formula that returns 4 in another cell, however this Google spreadsheet looks really complicated. Also I need to trim because I might have white spaces between the numbers.
948
The Non-Array Formula to Count Comma Separated Words in Google Sheets. You can use a LEN + SUBSTITUTE combo or LEN + REGEXREPLACE combo in this case.
You can use the =UNIQUE() and =COUNTIF() functions to count the number of occurrences of different values in a column in Google Sheets.
One option is to use the following formula:
=COUNT(SPLIT(A1; ",")) Here's an example:
146
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
