M mexmex Dec 27, 2009 #1 I have a list of names in a column and want to show the total number of entries in the column at the bottom.
I have a list of names in a column and want to show the total number of entries in the column at the bottom.
M Mike H Dec 27, 2009 #2 Hi, Providing there are no numbers in the range this should do =COUNTA(A1:A20) Mike
D Dave Peterson Dec 27, 2009 #3 If you want to simply count the number of entries in the range, you can use a formula like: =counta(a1:a10) (where A1:A10 contain your data) If you wanted to count the number of unique entries in that range, you could use a formula like: =sumproduct((a1:a10<>"")/countif(a1:a10,a1:a10&"")) (you can only use the entire column in xl2007)
If you want to simply count the number of entries in the range, you can use a formula like: =counta(a1:a10) (where A1:A10 contain your data) If you wanted to count the number of unique entries in that range, you could use a formula like: =sumproduct((a1:a10<>"")/countif(a1:a10,a1:a10&"")) (you can only use the entire column in xl2007)
