SUMIF formulas to unify 2 variables
Dear, I would like to ask for help with the following:
I am creating a summary sheet to quantify sales by seller as well as by sales area. There are sellers who have the possibility of generating sales in different business areas.
Therefore, as you can see in the first image I show this global summary sheet, however, in the second part of the image I would like to detail and I have not been able to find the correct formula.
I imagine that the formula would be SUMIF to be able to associate sales (NETO) for each seller (Assignado) & (Negocio)
I appreciate you can give me a hand. Thank you.
Help Article Resources
Check out the Formula Handbook template!