Adding together results from filtered data

%3CLINGO-SUB%20id%3D%22lingo-sub-3371718%22%20slang%3D%22en-US%22%3EAdding%20together%20results%20from%20filtered%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3371718%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20which%20is%20used%20to%20add%20up%20the%20total%20insurance%20premium%20for%20vehicles.%20The%20sheet%20is%20split%20into%20three%20sections%2C%20permanent%20vehicle%20additions%2C%20permanent%20vehicle%20deletions%20and%20temporary%20vehicles.%20This%20particular%20client%20is%20split%20into%20a%20number%20of%20franchisees.%20I'm%20trying%20to%20achieve%20a%20scenario%20where%20I%20can%20select%20a%20particular%20franchisee%20and%20a%20cell%20is%20completed%20with%20the%20total%20amount%20that%20this%20particular%20franchisee%20owes%20for%20their%20premium.%20I've%20included%20a%20screenshot%20of%20the%20excel%20sheet.%20I've%20had%20to%20block%20out%20sensitive%20data.%20Any%20assistance%20would%20be%20appreciated.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22screenshot_of_sheet.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371494i05DC409A705AC3C9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22screenshot_of_sheet.JPG%22%20alt%3D%22screenshot_of_sheet.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3371718%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a spreadsheet which is used to add up the total insurance premium for vehicles. The sheet is split into three sections, permanent vehicle additions, permanent vehicle deletions and temporary vehicles. This particular client is split into a number of franchisees. I'm trying to achieve a scenario where I can select a particular franchisee and a cell is completed with the total amount that this particular franchisee owes for their premium. I've included a screenshot of the excel sheet. I've had to block out sensitive data. Any assistance would be appreciated. screenshot_of_sheet.JPG

 

0 Replies