Auto excel in a number of these, the contents of the cell number

An existing excel, some cells do not, there are some cells, how can a few of which the contents of the cell number???

such as = COUNTA (A:A)
in accordance with the requirements of their own transformation quoted address.editor – location – location conditions – null – so determined

Not the content of the selected cell.

Editor and then – to delete to delete the value of these empty cells

and then take out on the line know how many of the content ..You assume that the number of those in the A1:C6 region, then you want to enter the cell to return to the formula:
= COUNTIF (A1:C6, “> 0”) editor – location – location conditions – air Value – to determine

Leave a Reply