formula to count visible cells with data only

[Iqbal_Khan]

What formula can I use to carry out the above in excel 

[#2 · Accepted solution]

@Iqbal_Khan Look into the AGGREGATE function. Use 2 or 3 in the first argument (COUNT or COUNTA) and 5 in the second (ignore hidden), and then the range you want to count. Such a formula could look like this (just an example):

=AGGREGATE(2,5,A2:A50)

[#3]

Thank you Riny, works like a charm