1. 首先在Column F 加入计算年份的formula



=YEAR(E2)

2. 然后修改你的filter formula，以便可以筛选年份



*2023年的计算 =(COUNTA(UNIQUE(FILTER(B3:B,C3:C="舞蹈",F3:F=2023))))

*2022年的计算 =(COUNTA(UNIQUE(FILTER(B3:B,C3:C="舞蹈",F3:F=2022))))

3. 图片参考

Source: ---

---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

---