In cell f2 enter a formula using countifs – Introducing COUNTIFS: A versatile function in Microsoft Excel, COUNTIFS empowers users to count cells that meet multiple specified criteria. This comprehensive…