Needed Formula

[Leonardo1234]

let us suppose column A contains
1
2
3
4
9


now what i want is i need the formula that will let me know that column A contains data in 5 cells i need that number in the results
here the result is 5 in this example

 

[Rodger]

=COUNTIF(A1:A100,"<>"&"")

specify your range

 

[Peter Bartholomew]

An alternative approach is to convert the data to a table (Ctrl+T) and count the rows.
Calling the Table 'data' enables the formula
= ROWS( data )
or, equally, following Rodger ,
= COUNTIF( data, "<>" )
If you leave spaces in the first column or place a value in the second column to expand the table, the formulas no longer agree but which is better depends upon your intended use of the number.

 

[Nikunj Rastogi]

counta(your_range)

 

[Leonardo1234]

Thnx Rodger,Peter and nikunj for giving ur precious time and great support to this post Problem Solved