Using SUM(IF()) as an array function instead of COUNTIF() with AND or OR criteria in Excel

In Microsoft Excel, the COUNTIF() function allows you to determine the number of cells in a range whose values match a certain criterion, but it does not allow you to use criteria involving the logical operators OR or AND. This article shows you how to...

support.microsoft.com