Sales Performance

Regions, payment statuses and sales occupy A2:C5. Selected region is in E2 and a target amount in G2. In F2, calculate Paid sales for that region. In F3, count its Paid orders. In F4, return Target met when the total is at least the target, or Below target otherwise.

Enter formulas in the highlighted output cells: F2, F3, F4. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.