Forum Discussion
Get total sales per customer
You probably already have an answer but I found a good solution and thought it might help others.
Use the Consolidate feature on the data tab.
Good video here https://www.youtube.com/watch?v=IGaq_biQ1B8
As Mr. Riny_van_Eekelen informed you, a simple pivot table would work.
Alternatively, you could also use the filter function or the existing templates from Microsoft, which are available to everyone.
Use these templates to track and report your weekly, monthly, and quarterly sales
Finally, with your permission, if I can recommend you, add a file (without sensitive data) to your project. Explain your plans in relation to this file.
So you can get a solution that is tailored to your needs much faster.
*Knowing the Excel version and operating system would also be an advantage.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone :).
I know I don't know anything (Socrates)