如何使用countifs计算多列 [英] how to count multiple columns using countifs

问题描述

我正在输入一个公式来计算需要引用的次数在给定的列中用字母 Q 表示，当我将公式输入一列时，我得到了正确的答案，但是当我想为多列做这件事时，我得到零，有人可以帮忙吗?公式是

I am putting in a formula to count the number of times a quote is required Indicated by the letter Q in a given column, when I put the formula in for one column I get the correct answer, but when I want to do it for multiple columns I get zero, can anyone help please? the formula is

=COUNTIFS(D10:D29,"=Q",G10:G29,"=Q")

推荐答案

尝试其中一个

=SUMPRODUCT((D10:D29="Q")+(G10:G29="Q"))

或

=SUMPRODUCT(((D10:D29="Q")+(G10:G29="Q")>0)+0)

如果您在 D10 和 G10 中都有 Q，前者将计数为 2 - 即使有两个Q"，后者也最多只对每一行计数一次

the former will count 2 if you have Qs in both D10 and G10 - the latter only counts each row once at most, even if there are two "Q"s

这篇关于如何使用countifs计算多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！