I mentioned that the data is in a Table object—this is important if you want the functions to update automatically. How to use COUNTA () to count the items in the unique list in Excel ...