The table structure that I have right now is as below:
我现在的表格结构如下:
Column A Column B
Apple 1
Apple 2
Apple 1
Orange 1
Orange 2
I am trying to write a formula where, for all the cells with the value of Apple in column A, I get the total count for values in column B equal to 1.
我正在尝试编写一个公式,其中,对于A列中具有Apple值的所有单元格,我得到B列中值的总计数等于1。
Please help.
1 个解决方案
#1
3
As far as I can tell, you are just after the formula
据我所知,你只是在公式之后
=COUNTIFS(A:A,"Apple",B:B,1)
#1
3
As far as I can tell, you are just after the formula
据我所知,你只是在公式之后
=COUNTIFS(A:A,"Apple",B:B,1)