COUNTIF (or Sumproduct) for Multiple Columns, Array Criteria, using AND / OR conditions Column H formulas use COUNTIF or SUMPRODUCT functions to Count with respect to Multiple Columns and multiple criteria, using AND / OR conditions ie. count if either of the multiple conditions is satisfied, as described below.

To count rows that contain specific values, you can use a formula based on the MMULT, TRANSPOSE, COLUMN, and SUM functions. In the example shown, the formula in G6 is: =SUM (-- (MMULT (-- (data=G4),TRANSPOSE (COLUMN (data)^0))>0)) where data is the named range B4:D15. The result is 5, the number of rows that contain the number 19.

In Excel, you can count cells in a range using the COUNTIFS or FILTER functions. For example, the FILTER function can handle AND or OR conditions, and then you can apply COUNTA to count the resulting rows.

COUNTIFS is used to count cells that meet multiple criteria. Each COUNTIFS handles one set of AND conditions, and the + creates an OR scenario between them. For example, to count rows where Column A contains 'Fruit' and Column B has 'USA', use: `=COUNTIFS(A:A, "Fruit", B:B, "USA")`. This formula only counts rows if both conditions are met in different columns.