Return Rates by Category and Size with COUNTIFS
This lesson is part of the course
In this lesson
You count lines and returns per category and per size with COUNTIF and COUNTIFS, compare the return rate by units with the rate by value, and name the problem category.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Return Rates by Category and Size with COUNTIFS Locked
- Return Reasons: Shares, Cumulative Share and the Pareto Chart Locked
- Cost per Return: Shipping, Handling, Refurbishment and Write-offs Locked
- Refund vs Exchange vs Store Credit: the Resolution Mix and Its Margin Effect Locked
- Restock Rate and Value Recovery: New, Open Box or Write-off Locked
- Serial Returners: Returns per Customer, Thresholds and Review Flags Locked
- Return Window and Time to Refund: Date Maths and Service Levels Locked
- Policy Scenario: Paid Returns, Fewer Returns vs Lost Sales (with Chart) Locked