Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet much like the one on this page: Painless Software Schedules

Sample Spreadsheet

I wish to create a summary sheet with the Feature against the totals for that feature of "Orig Est", "Curr Est", "Elapsed" and "Remain".

Is there an appropriate Excel feature to generate this summary? Preferably one that will automatically update?

share|improve this question
up vote 1 down vote accepted

You can use a Pivot Table to do that. You can find out how you can make use of Pivot Tables in Excel 2003 here.

share|improve this answer
This is great - it worked, but took some fiddling: I struggled to get the columns "Orig Est", "Curr Est", "Elapsed" and "Remain" along the top. To do this, I used the "Format Report" option and selected one of the formats. This seems to have worked. There's probably a specific setting to achieve what I wanted, but I'm up and running with what I needed, so you get the tick. – Don Vince Apr 14 '10 at 13:49
Nice to help you. – Mehper C. Palavuzlar Apr 14 '10 at 16:07

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .