数据有缺失值#N/A怎么办？

知道了，参见：https://blog.csdn.net/luocm/article/details/39393507#:~:text=%E5%A6%82%E6%9E%9C%E6%95%B0%E6%8D%AE%E4%B8%AD%E5%87%BA%E7%8E%B0%E8%BF%87%23N%2FA%E3%80%81%23DIV%2F0%21%E7%AD%89%E7%B3%BB%E5%88%97%E9%94%99%E8%AF%AF%E6%97%B6%EF%BC%8C%E5%86%8D%E6%B1%82%E5%92%8C%E3%80%81%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%81%E4%B8%AD%E4%BD%8D%E5%80%BC%E6%97%B6%E6%97%A0%E6%B3%95%E5%BE%97%E5%88%B0%E7%BB%93%E6%9E%9C%EF%BC%8C%E8%BF%99%E6%97%B6%E6%9C%89%E4%B8%A4%E7%A7%8D%E8%A7%A3%E5%86%B3%E5%8A%9E%E6%B3%95%EF%BC%8C%E5%8E%9F%E7%90%86%E5%B0%B1%E6%98%AF%E9%80%9A%E8%BF%87iferror%20%28%29%E5%87%BD%E6%95%B0%EF%BC%8C%E5%B0%86%E5%BC%82%E5%B8%B8%E5%80%BC%E6%9B%BF%E6%8D%A2%E4%B8%BA%E7%A9%BA%E5%80%BC%EF%BC%88%22%22%EF%BC%89%EF%BC%8C%E8%AF%A6%E8%A7%81%E9%99%84%E4%BB%B6%E3%80%82,%E6%96%B9%E6%B3%951%EF%BC%9A%20%E5%A5%97%E7%94%A8iferror%E6%9B%BF%E6%8D%A2%E5%BC%82%E5%B8%B8%E5%80%BC%E4%B8%BA%E7%A9%BA%E5%80%BC%EF%BC%88%22%22%EF%BC%89%E4%B8%8D%E5%8F%82%E4%B8%8E%E8%AE%A1%E7%AE%97%EF%BC%8C%E5%86%8D%E4%BD%BF%E7%94%A8%E6%95%B0%E7%BB%84%E5%87%BD%E6%95%B0

怎么分组求中位数或者其他分位数

=MEDIAN(IF(($A$2:$A$162=E2)*($B$2:$B$162=F2),$C$2:$C$162))求中位数

=PERCENTILE

(IF(($A$2:$A$162=E2)*($B$2:$B$162=F2),$C$2:$C$162)，0.5)也可以求中位数

PERCENTILE可以求0-1的分位值，将0.5改成相应数值即可

【excel函数小技巧】多种前置条件下的中位数该如何计算？_excel 条件中位数-CSDN博客