Hide/show detail of cell categories in Excel 2010

Please reference the attached spreadsheet.  What I want to do is only show the summary of each Account# and Account Name with a total of each.  If the user wants to see the detail, they should be able to click on a drop-down for each account#/name to see each line item.  For example, when only showing summary, only rows 1, 2, and 7 will be displayed.  Cells c2 and c7 should display "total" and cell d2 will and the sum of d3:d5 and d7 the sum of d8:d10.  I appreciate any guidance to get this work in some form of what I have explained.
sample.xlsx
shannon_adamsAsked:
Who is Participating?
 
ProfessorJimJamCommented:
here it is attached.

you can achieve this by using the subtotal function that is found in the Data tab.
sample.xlsx
0
 
shannon_adamsAuthor Commented:
Perfect!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.