excel公式小计

统计某列大于某个值的个数

=COUNTIF(E2:E5889,">10") =COUNTIF(E:E,">10")

保留小数点后两位并拼接字符串

=ROUND(MAX(E:E),2)&"秒"