Hello team;
I am looking to count all comma's within the cells of my column "F".
I tried this formula but get a #spill error.
=LEN(F:F)-LEN(SUBSTITUTE(F:F,","""))
Hello team;
I am looking to count all comma's within the cells of my column "F".
I tried this formula but get a #spill error.
=LEN(F:F)-LEN(SUBSTITUTE(F:F,","""))
How aboutFormula:
=SUM(LEN(F:F)-LEN(SUBSTITUTE(F:F,",","")))
Thank you so much Fluff13.
Works perfect.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks