[算表] countif的criteria設定?
軟體:EXCEL
版本:2003
譬如說
A
1 cat
2 cat
3 cat
4 apple
5 apple,cat
=countif(A1:A5,"cat") 答案值為3
=countif(A1:A5,"apple") 答案值為1
5A的地方有同時出現apple和cat
countif可以計算出某個欄位有出現的單字嗎?
就是答案變成
cat 出現4次
apple 出現2次
感謝!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 203.65.55.201
推
02/25 09:22, , 1F
02/25 09:22, 1F
→
02/25 09:30, , 2F
02/25 09:30, 2F
→
02/25 09:40, , 3F
02/25 09:40, 3F
→
02/25 09:43, , 4F
02/25 09:43, 4F
→
02/25 10:42, , 5F
02/25 10:42, 5F
推
02/25 11:00, , 6F
02/25 11:00, 6F
→
02/25 11:00, , 7F
02/25 11:00, 7F
→
02/25 11:01, , 8F
02/25 11:01, 8F
→
02/25 11:02, , 9F
02/25 11:02, 9F