I have two array formulas, one that SUMS several figures based on two sets of conditions, and one that COUNTS several figures, based on the same conditions. When I enter the SUM as an array formula, it calculates correctly. However, when I try the same approach using the COUNT as an array, it does not return a valid answer. I have attached a sample file that illustrates the problem.
Thanks in advance for any assistance on this.