Select cell D$27.$

Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group.

Use cells $C$$5$:$C$$19$ as the Range argument.

Set a Criteria argument that will select all boats in the $$Beneteau$$ group. The criteria is ben$*.$ If you type the formula, include quotation marks.

Copy the formula in cell D$27$ to cells D$28$:D$30.$

Edit the criteria in each copied formula in cells D$28$:D$30$ to reflect the boat make.