Hi, thanks for reading this post!
(1) I have a table with the data, like this:
(2) On another sheet, I'm creating a report, like this:
I'm having a headache finding the formula for second column. I'm running 365 and I've tried the following: Nesting a MAXIFS with a SUMIFS, looking with a XLOOKUP then. This doesn't work so I see there must be a way for this.
I would appreciate your help!
(1) I have a table with the data, like this:
Client | Salesperson | Sales ($) |
Mike | 1,000 | |
Apple | Jim | 5,000 |
Apple | George | 4,000 |
Apple | George | 3,000 |
... | ... | ... |
(2) On another sheet, I'm creating a report, like this:
Client | Frequent/Max Salesperson | Sales ($) |
Mike | 1,000 | |
Apple | George | 7,000 |
I'm having a headache finding the formula for second column. I'm running 365 and I've tried the following: Nesting a MAXIFS with a SUMIFS, looking with a XLOOKUP then. This doesn't work so I see there must be a way for this.
I would appreciate your help!