Excel Search

%3CLINGO-SUB%20id%3D%22lingo-sub-2060723%22%20slang%3D%22en-US%22%3EExcel%20Search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060723%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%E2%80%99m%20struggling%20to%20find%20a%20formula%20to%20search%20the%20excel%20document%20to%20find%20the%20total%20number%20of%20sales%20from%20each%20product%20from%20all%20customers.%20I%20have%20attached%20a%20diagram%20to%20try%20and%20help%20explain%20what%20I%E2%80%99m%20trying%20to%20figure%20out%20as%20I%20don%E2%80%99t%20really%20know%20how%20to%20explain%20it%20very%20well.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22364AC94C-AC86-4DDE-B840-D720D189E95E.jpeg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246392i5F10AEB09C584E6A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22364AC94C-AC86-4DDE-B840-D720D189E95E.jpeg%22%20alt%3D%22364AC94C-AC86-4DDE-B840-D720D189E95E.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2060723%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2060826%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F929014%22%20target%3D%22_blank%22%3E%40Harri39wj%3C%2FA%3E%26nbsp%3BA%20pivot%20table%20could%20probably%20do%20that%20for%20you.%20Would%20be%20helpful%2C%20though%2C%20if%20you%20could%20provide%20a%20workbook%20with%20the%20some%20(fake)%20data%20in%20it%2C%20showing%20what%20you%20have.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2061700%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2061700%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bapologies%20please%20find%20the%20sheet%20attached%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

  I’m struggling to find a formula to search the excel document to find the total number of sales from each product from all customers. I have attached a diagram to try and help explain what I’m trying to figure out as I don’t really know how to explain it very well.364AC94C-AC86-4DDE-B840-D720D189E95E.jpeg

4 Replies

@Harri39wj A pivot table could probably do that for you. Would be helpful, though, if you could provide a workbook with the some (fake) data in it, showing what you have.

@Riny_van_Eekelen apologies please find the sheet attached

 

Spoiler
 

@Harri39wj Consider recording all transactions in one sheet and adding a column for what you call "A/C" (i.e. "Source" 1 to 9). Then you can make pivot tables, summarising the data by Source and by Product, as shown in the attached file.

Now, you would have to add some tables with information on Companies, Stores and Prices for each product to create the overviews you want. 

@Riny_van_Eekelen no problem thank you for your help this is going to be such a time saver thank you!!