Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-869040%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869040%22%20slang%3D%22en-US%22%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EWorking%20in%20tables%20once%20I%20have%20done%20a%20sort%20by%20State%20How%20do%20I%20go%20about%20calculating%201)%20the%20number%20of%20stores%20and%202)%20the%20total%20value%20of%20the%20Delivery%20costs%2C%20for%20the%20refined%20data%20displayed%20once%20I%20done%20a%20sort%3F%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-869040%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-870300%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870300%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20attached%20the%20workbook%20here%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413083%22%20target%3D%22_blank%22%3E%40Gavin59%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-871179%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20link%20to%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-871179%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F102179%22%20target%3D%22_blank%22%3E%40Paras%20Dodhia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Working in tables once I have done a sort by State How do I go about calculating 1) the number of stores and 2) the total value of the Delivery costs, for the refined data displayed once I done a sort?
2 Replies

Can you attached the workbook here? @Gavin59