Excel 2000 data question

The answer is yes, absolutely. It depends how you have the data set up, though. If it's all in one table with one line per record and no empty cells (put a dash in or a zero - just don't leave empties), you might try Subtotals in the Data menu. Some of the database functions might help you, too - read help on database functions. Or, you might even like Pivot Tables - also on the Data menu. If Help isn't helpful enough, consider taking an Intermediate level Excel class. For more flexibility with the data, though, you might consider exporting it to Access.

This question was closed by the author