Sep 19 2020 05:26 AM
How can I:
if any entry in Column D = employee AND any corresponding row entry in Column E = client ADD the corresponding row $ in Column I to Cell N7,
The employee is assigned dozens of clients and every sale is entered in order placed regardless of employee or client, so Column D is not sorted by employee, nor is the client Column E, its just chronological.
Thank you,
John
Sep 19 2020 05:39 AM
John, from that it's not clear what is an issue with SUMIFS() formula. Perhaps you may attach small sample file without sensitive information.
Sep 19 2020 06:57 PM