I'm new on Google Sheets, but I only use it for simple tasks. Still, I encountered a problem that I can not solve. I will start with an image of my google test sheet below:

If you look at the picture above, there is a screenshot of a test sheet showing the problem that I do not know how to solve. Column A uses the formula = IF (E3 <> "", COUNTA ($ E $ 3: E3), "") to count and number the values in column E.

I then copied and pasted the values from column A into column C and attempted to do the same calculation in column B of column C, changing the values a few times. The same formula (now placed in column B) COUNTS values, but no longer skips empty cells. Does anyone know why this is? I guess it has something to do with "Editing> Paste Special> Paste Values Only", which does not work as I think, but something is now in the empty columns in column C that I can not no see. Or maybe I do not understand the formula?

Summary: Why does the formula: = IF (E3 <> "", COUNTA ($ E $ 3: E3), "") work between column A and column E, but does not work in the same way between column B and column C? I would like it to count the values AND ignore the empty cells. This image is a small-scale version of a much larger Google sheet, but the problem is the same. I need to be able to edit a column, then recount / renumber the values.

Thank you!

PS I've tried sharing this sheet with Google, but Google does not allow me to share it with anyone because I have to allow access to specific people. If someone wants to inspect it, I can export it and download it to a Google reader.

Zach

EDIT: I thought that it would be useful to add clearly what I am looking for –

I would like the formula in column B to ignore empty cells in column C, generating 13 to the last cell (cell B24) instead of 22.