In this post I would like to present a solution to the situation in which we wish to count the number of rows for which a stipulated condition is met in at least one of several columns.
To illustrate what is meant by this, consider the extract below:
which details levels of scrap nickel exports for various countries and for various years (you can download the workbook here).