| I'd argue that this data would best be kept in a database such as Access, but that would be off-topic. One thing that can be done in Excel is have the number calculated based on the presence of information in other columns. The attached spreadsheet illustrates this using the COUNTA function. The formula in the cells in column A check for contents in the column B cells and return an empty string ("") or a count of non empty cells in column B to the current row followed by a period. |