Count birthdays by year in Excel

Learn how to count birthdays by year in Excel using SUMPRODUCT, COUNTIFS, and dynamic array formulas, with simple examples even beginners can follow.