I have a large number of rows manually hidden on my excel sheet, and this is interfering with my count functions. Does anyone know a formula to count (or number) the number of visible rows? And is there a formula that can be used to count the number of visible blanks?
When I use the COUNTBLANKS function, it returns to me the number of hidden and visible blanks. The subtotal(3,range) or subtotal(103,range) functions only count visible text.
For example, in the file attached with hidden rows I'd like it to say 10 for number of rows and 6 for number of blanks.
Thanks
Bookmarks