--------
average(E16{E16<>""})
AVERAGE(greparray(E16,abs(item) != 0))
===========
效果
==================
QQ录屏20220825161648.rar