5 Mar 2006 at 11:50 #1 A[L]C A[L]C Soldato Joined 18 Oct 2002 Posts 7,514 Location Maidenhead What is the formula to count how many cells are populated with data? ie I have a list of names and want to count how many names are in a range Thanks
What is the formula to count how many cells are populated with data? ie I have a list of names and want to count how many names are in a range Thanks
5 Mar 2006 at 11:58 #2 A[L]C A[L]C Soldato OP Joined 18 Oct 2002 Posts 7,514 Location Maidenhead found it =COUNTA(B2:B27)
![A[L]C](/styles/overclockers/avatars/7.png){kind=avatar}