Computers and Software > Computers and Software - General
What am I doing wrong?
inkman996:
Below is a screen shot of my problem. What I am trying to do is sum how many of a specific character is with in a cell or with in a range. The reason why is I have a spread sheet from a customer with over 2K player numbers needed. I need to know how many of each specific digit there is so I can order pre cut numbers accordingly. Many of the player numbers are even triple digit, its for a boot camp.
I am practicing how to do the formula but I am messing up some how ie the error. It may be because I am using open office and the syntax is different? Or did I forget something completely?
3Deep:
My wife is going through the same thing right now with a spread sheet trying to print out on 8.5 x 11 paper and getting half cut off, we hate when people send crap on spread sheets
aauusa:
The formula is =LEN(CELL LOCATION) If item is in cell a3 and you want the answer in cell b3 the in cell b3 place the formula =len(a3).
aauusa:
looking back at what you are trying to do this is what you need to do. all names need to be in 1 cell, then you can make a list of letters on the side for you letter selection and the enter this formula
=LEN(A2)-LEN(SUBSTITUTE(A2,G2,"")) A2 is the cell with all names g2 is where the letter to be counted is located(off to the side)
inkman996:
--- Quote from: aauusa on November 16, 2021, 10:55:30 AM ---looking back at what you are trying to do this is what you need to do. all names need to be in 1 cell, then you can make a list of letters on the side for you letter selection and the enter this formula
=LEN(A2)-LEN(SUBSTITUTE(A2,G2,"")) A2 is the cell with all names g2 is where the letter to be counted is located(off to the side)
--- End quote ---
You are very close but even with your exact formula I am still getting an error. In your example what are you counting?
Navigation
[0] Message Index
[#] Next page
Go to full version