You're an AR analyst preparing the past-due invoice rollup for the credit committee. Columns A–B hold 18 open invoices and the number of days each is past due. Three relative-threshold buckets are pre-populated in column E: >30, >60, >90.
Your task:
- In column F (Count), write a COUNTIF that returns the number of invoices matching each threshold in column E.
- The formula must drag-fill from F2 → F4.
Graded cells: F2 (>30), F3 (>60), F4 (>90).
Open this problem on a desktop to attempt it.