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.
@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.