excel countif函数中,条件设置为大于某个单元格数字怎么设置

转: http://ift.tt/1AVscrv

问:

如大于D4,">D4",但实际统计时是计算的D4,而不是D4单元格中的数值,怎么办?我要的是大于那个单元格中的数值,谢谢
我是有一列数,求这列数中大于本列数之和的0.9倍值和小于本列数值之和的1.1倍,怎么设置
 
答:
求数值用if函数

求个数用countif函数 =countif(A:A,">"&D4)

实在不行就用sum(if())镶嵌的数组函数,不过应该不会不行

countif函数的参数不能引用
 
尼玛这个折腾死了……  

http://ift.tt/1AVse2F

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s