Home

Excel Table data for "roll up" report

%3CLINGO-SUB%20id%3D%22lingo-sub-500226%22%20slang%3D%22en-US%22%3EExcel%20Table%20data%20for%20%22roll%20up%22%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-500226%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20store%20location%20details%20-%20specifically%20issue%20tracking%20in%20a%20table%20and%20would%20like%20to%20be%20able%20to%20have%20a%20formula%20on%20a%20separate%20sheet%20(same%20workbook)%20roll%20up%20all%20noted%20issues.%26nbsp%3B%20I%20have%20attached%20a%20sample%20worksheet%20with%20an%20example%20of%20what%20I%20am%20trying%20to%20accomplish.%26nbsp%3B%20I'm%20very%20new%20to%20Excel%20and%20appreciate%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-500226%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Sta_plt8541
Occasional Visitor

Hi,

 

I am trying to store location details - specifically issue tracking in a table and would like to be able to have a formula on a separate sheet (same workbook) roll up all noted issues.  I have attached a sample worksheet with an example of what I am trying to accomplish.  I'm very new to Excel and appreciate any help.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies