| count(Sheet1!a2:a&($b$2),"=200") [message #206509] |
Fr, 02 Juni 2006 04:09 |
|
|
我想在Seet2中统计Sheet1中A2：A(b2)中等于200的值 ，但公式中的b2是在Sheet2中的一个可改变的数 ，不知有没有能实现的方法，敬请大师指点!
|
|
|
| Re: count(Sheet1!a2:a&($b$2),"=200") ʵ [message #206510 ] |
Fr, 02 Juni 2006 04:17 |
|
൹,Ĺʽʵֲ˵. .Դ
,ô.
--
ʼ!
"ʦ" <????? [at] discussions.microsoft.com> дʼ
news:F7BF6D87-523F-4AD3-B981-C73A74D84861 [at] microsoft.com...
> Seet2ͳSheet1A2A(b2)е200ֵʽеb 2Sheet2
һɸıֵ֪ûʵֵķʦָ!
|
|
|
| Re: count(Sheet1!a2:a&($b$2),"=200") ʵ [message #211114 ] |
Sa, 03 Juni 2006 02:20 |
|
COUNTIF(INDIRECT("Sheet1!A2:A"&B2),"=20")
--
÷
http://needfun.cn/
"ʦ" <????? [at] discussions.microsoft.com> дϢ
news:F7BF6D87-523F-4AD3-B981-C73A74D84861 [at] microsoft.com...
> Seet2ͳSheet1A2A(b2)е200ֵʽеb 2Sheet2еһɸıֵ֪ûʵֵķ ʦָ!
|
|
|
| ôʼ [message #213198 ] |
Do, 08 Juni 2006 14:25 |
|
|
ˣϢһ
|
|
|
| Re: ôʼ [message #223978 ] |
So, 16 Juli 2006 17:56 |
|
վ
"yuwei" <cat990627 [at] sina.com> дϢ:urwtQ%237iGHA.2220 [at] TK2MSFTNGP05.phx.gbl...
> ˣϢһ
>
>
|
|
|
