SUMIF

SUMIF allows you to sum values in a range based on a specific criterion. For example, if you have a list of sales figures and you want to sum the values for a particular salesperson, you can use SUMIF to do this. On top of that, you can use SUMIF with multiple criteria by using the SUMIFS function, e.g., to sum the values for a particular salesperson and a specific product.

Sum by Sales Person AND by Product  - Please note that the values to be summed needs to be specified first, then followed by each criteria range and the respective selected criteria.