Customer Orders Analysis
Count open and late orders with COUNTIFS: blank ship dates, a name stem that matches two customers, a threshold that includes its limit, and a safe percentage.
What you will practise: Count rows that meet several conditions, including blank and non-blank cells, wildcard text and inclusive limits, and turn two counts into a percentage that cannot fail.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.