Enter a COUNTIF function in cell C$3$ on the Summary worksheet that counts the

number of stores by region. Define the $$range$$ argument with the range A$4$:A$40$

on the Sales and Inventory worksheet. This will add cell capacity to the function

through row $40.$ Add an absolute reference to this range. Define the $$criteria$$

argument with cell A$3$ on the Summary worksheet.