There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

For deeper dives, check out my earlier articles on creating relational tables and creating relational databases. How to create an Excel table 1. First, enter the field names in the columns across ...

VLOOKUP Here, I have a list of exam grades and the scores required for each grade (let's call this table 1). I also have a table containing students' scores (table 2 from this point).

Excel tables provide superior tools for working with data in list form. If you want to sum columns of data automatically so that the totals show only the sum of visible cells (for example), Excel ...

Using Excel 2013's Frequency function as an array quickly compiles the frequency data from a list of "bin" ranges. You can then display this data on a bar chart to more readily compare the ...

Figure E The SharePoint list contains the same records as the Excel table. You will have full access to the data and the structure. Those you share the list with can view and edit the data.