Excel精英培训网

 找回密码
 注册

不重复计数遇到空格

已有 801 次阅读2014-5-14 13:18

=SUM(IFERROR(1/COUNTIF(A3:A19,A3:A19),))三键

评论 (0 个评论)

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-5-4 12:46 , Processed in 0.205633 second(s), 7 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

返回顶部