Count If语句忽略隐藏行

Question

我有一个值为"Y"或"N"的列。我如何计算列中有多少值是"Y"，而行没有隐藏?

Answer 1

Used

=SUMPRODUCT(SUBTOTAL(3, OFFSET(C7:C13,ROW(C7:C13)-MIN(ROW(C7:C13)),,1)), – -(C7:C13=B2))

从这里

Answer 2

你有没有试过玩

=COUNTIF(A:A,"Yes")还是=COUNTIF(A:A,"No")