Excel筛选后怎么样计算筛选结果的行数

在使用SUMPRODUCT函数时，如果要忽略隐藏行对数据区域进行统计，可以使用以下公式：=SUMPRODUCT(1/(1/SUMPRODUCT(a2:a50,1/SUMPRODUCT(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50,1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2:a50/(1/SUMPRODUCT(a2: