Hi all,
I am trying to fix a broken formula.
Using count function i am trying to count all number cells in the range. This works fine except for when the cell has a space or - or / or : basically if i use anything in the cell other than numbers.
The aim is to use the sheet as a rota. Im trying to count the amount of staff that are on shift. 99% of the staf work set shift patterns so they know if they start at 8.15 then their finish time will be 6 hence why there are no finish times. However there are a couple of staff that do smaller and or random shifts and they require a start and finish time. How can i get the cell to count all of the numbered cells???
Thanks in advance
I am trying to fix a broken formula.
Using count function i am trying to count all number cells in the range. This works fine except for when the cell has a space or - or / or : basically if i use anything in the cell other than numbers.
The aim is to use the sheet as a rota. Im trying to count the amount of staff that are on shift. 99% of the staf work set shift patterns so they know if they start at 8.15 then their finish time will be 6 hence why there are no finish times. However there are a couple of staff that do smaller and or random shifts and they require a start and finish time. How can i get the cell to count all of the numbered cells???
Thanks in advance
