Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.