计数如果两个条件匹配 - EXCEL公式 [英] Count if two criteria match - EXCEL formula
本文介绍了计数如果两个条件匹配 - EXCEL公式的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
A
和列<$ ç$ C> C 。 示例:
如果列 A
值为M(男),而列 C
是YES,那么它会算。
有人可以帮我吗?
解决方案
添加单元格的表单名称,例如:
= COUNTIFS(stock!A:A,M,stock!C:C,是)
假设工作表名称为库存
I have this table and I would like to create a formula which would count values based on true conditions from column A
and column C
.
Example:
If in column A
value is M (male), and in column C
is YES, then it would count.
could anyone help me with this formula?
解决方案
Add the sheet name infront of the cell, e.g.:
=COUNTIFS(stock!A:A,"M",stock!C:C,"Yes")
Assumes the sheet name is "stock"
这篇关于计数如果两个条件匹配 - EXCEL公式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文