Hello. I would be delighted to assist you. Can I conclude that you have prepared a Microsoft Excel spreadsheet that includes the required data? It should certainly be straightforward to solve this problem for you. However, I need a bit more information. Would you be able to post the spreadsheet (XLS format, please, NOT XLSX) and give me a specific example of what columns and rows you want totaled under what conditions? Thank you for your cooperation.
Thank you. I'm not interested in stealing your confidential data!! Please try to provide a complete spec.
Did you want a total for every customer, or do you just want to enter a customer into a cell and calculate then and there for that customer?
Yes, I can provide Excel formulas that will do just what you like. I understand that you want a total displayed for each client. I also understand that you want the top ten clients indicated.
There is no direct way to retrieve all customers for which the sum is among the ten largest. This has to be done indirectly by macros that determine the top ten costs; use a database conditional scenario to find customers that correspond to those costs; and displaying those customers' names in another group of cells.
However, all extremely doable. Just rather more work than you may have hoped. It certainly won't take you hours upon hours of tedious, error-prone manipulation.
That's terrific--even more terrific as there is no "formula" for selecting the individual values from a range.
You could, of course, DUPLICATE the per-customer total for EVERY line that deals with that customer.
Best of luck!