Forum Discussion
Solved
formula to count visible cells with data only
What formula can I use to carry out the above in excel
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)
2 Replies
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)
- Thank you Riny, works like a charm
