本文介绍了计数如果两个条件匹配 - EXCEL公式的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这个表,我想创建一个公式,它将根据 A 和列 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"
更多推荐
计数如果两个条件匹配
发布评论