Hi All,
I am trying to solve this scenario.
Column A: Cars (Toyota, Chevy, GMC, etc.)
Column B: Salesperson (John, Lance, Kathy, Kassidy)
Im trying to do a countifs function to get the total amount of any two specific salesman. For example, i want to know how many toyotas both John and lance sold. I tried =COUNTIF(A1:A10, "=Toyota", B1:B10, "=John", A1:A10, "Lance") but it comes up with "0" im guessing because the three criterias are not being met. I know i can do two separate countif functions and add them but i wanted to see if it could be done in one.
Also,
adding to the above statement. Column C: Duration in days (10, 20, 5, etc.) i am trying to also do an averageifs function for the above scenario. For example, on average how long did it take john and lance to sell those toyotas. But i keep getting an error. I am trying =AVERAGEIFS(C1:C10, A1:A10, "=Toyota",B1:B10, "=John", A1:A10, "Lance")
Thank you for the help!
Bookmarks