Help in cell format

I am inputting data into the excel sheet in Microsoft office 2016, I have multiple copies of invoice or bill for data entry.

Example of different column A|B|C|: Name, Telephone, Invoice
Example Data input A|B|C|: John, 1234567, 1 of 3

How do I format or input a formula for column C so when I type it will be 3 of 9 OR 3/9 (meaning 3rd copy of the invoice with 9 copies in total)
Example I type in 25 enter into next row or down arrow, it will auto convert to 2 of 5 or 2/5

Select the C column and press control+1 Number-> Custom-> put #"/"# or #" of "# in type and then ok

Originally Posted by shukla.ankur281190

Select the C column and press control+1 Number-> Custom-> put #"/"# or #" of "# in type and then ok

For example: I type 19 with your format "#"/"# " enter it will show as 1/9 (1 out of 9), so if I want to drag down the cell then it will 2/9, 3/9 till 9/9 how do I do it?

Then if I have 10 out of 25 invoice using the format cannot work, it don't show correctly, how can I do it to let it show 10/25

Then you will have to format cells as #"/"9

Would you tell us why hand type 19 or 25 and then depend upon formatting to do what you want.

Perhaps use COUNTIFS&"/"&COUNTIFS would do what you want?

See the attached.

Or am I missing something?