CountIf on only one cell
I am trying to use CountIf on one cell to count all the comma's in the cell, but it keeps coming back with a 0. Is there another command I should be using for this? My formula looks like this: =COUNTIF(Sheet1!C1,",*")
Try this:
Excel really needs a function that does that.=LEN(Sheet1!C1)-LEN(SUBSTITUTE(Sheet1!C1,",",""))
Worked perfectly! That's a huge help thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks