In cell d15 enter a formula using a counting function – In the realm of data analysis, the COUNT function stands as an indispensable tool, empowering users to efficiently enumerate…