且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

COUNTIFS在单个公式中使用多个条件

更新时间:2022-12-12 22:36:59

您需要在sum函数中使用您的公式如下:

You need to use your formula in a sum function like this:

=SUM(COUNTIFS(A1:A21,{"Apples","Oranges"},B1:B21,">0"))

原因是,您的函数创建一个数组,苹果和橘子。您必须总结这个数组中的元素以获得所需的结果。

The reason is, that your function creates an array with the counts of apples and oranges respectively. You have to sum the elements in this array to get your desired result.