更新时间: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.