P petprincess Apr 21, 2008 #1 I am trying to count rows in a spreadsheet that there are hidden rows. Everything I try always counts the hidden rows. Anyone?
I am trying to count rows in a spreadsheet that there are hidden rows. Everything I try always counts the hidden rows. Anyone?
P Peo Sjoblom Apr 21, 2008 #2 Excel 2003 and later =SUBTOTAL(103,A2:A40) will only count visible rows in A2:A40 assuming they are not empty If you have an earlier version you would need VBA -- Regards, Peo Sjoblom
Excel 2003 and later =SUBTOTAL(103,A2:A40) will only count visible rows in A2:A40 assuming they are not empty If you have an earlier version you would need VBA -- Regards, Peo Sjoblom