To count numbers with 4 digit/5 digit with given Range.

Hi Charles,

I have solved this basis below assumptions:-

1) These are formulas not text like ("= 4588/2566")
2) The structure will always be either 4 digits divided by 4 digits OR 5 digits divided by 5 digits
3) / i.e., hypen may or may not be there

If you clarify on above, many other exceptions and complexities can be handled and I can built a dynamic formula to handle them.
See the attached file and let me know if I am on the right track.

Regards,
DILIPandey

<click on below 'star' if this helps>

In its' simplest form based on your sample

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter not just Enter
If there are also single numbers in the range then the formula would become

Please Login or Register  to view this content.

However I am sure that there is more to your problem than that, best you post a sample workbook with a few examples of your data/tables.