Find the Error — COUNTIFS Reports Zero on Live Customers

A revenue analyst's "orders per customer" rollup is reporting 0 for customers that obviously have orders in the data. Their formula looks right:

=COUNTIFS($A$2:$A$16, D2)

But every result is 0 or close to it.

Hint: open one of the customer-name cells in column A and look very closely at where the text begins and ends. CSV imports preserve quoted leading/trailing whitespace, and COUNTIFS is whitespace-sensitive. "Acme Corp " (trailing space) does not match "Acme Corp".

Wrap the comparison in TRIM. COUNTIFS doesn't accept array arguments natively, so the cleanest fix uses SUMPRODUCT with TRIM:

=SUMPRODUCT((TRIM($A$2:$A$16)=D2)*1)

The *1 coerces the boolean array to numbers; SUMPRODUCT sums them; the result is the count of rows where the trimmed customer name equals D2.

Your task:

1. In column E (Order Count), write a corrected formula that returns the right count for each customer in column D regardless of stray whitespace in column A.

Graded cells: E2 (Acme Corp), E3 (Hooli), E4 (Initech) — chosen because each lookup hits a customer with at least one whitespace-corrupted row, so the broken COUNTIFS would undercount all three.