使用CountIf函数即可以。
用法
| A | B |
| Data | Data |
| apples | 32 |
| oranges | 54 |
| peaches | 75 |
| apples | 86 |
| Formula | Description (Result) |
| =COUNTIF(A2:A5,"apples") | Number of cells with apples in the first column above (2) |
| =COUNTIF(B2:B5,">55") | Number of cells with a value greater than 55 in the second column above (2) |
1010
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
