Counts min and max quantity of equals 'strings' based on a filter column

[June7]

For a start, figure out how to calc min and max values - How to Find Lowest Value with Criteria in Excel (7 Effective Ways) (exceldemy.com)

Minimum must be number greater than 1?

You want to use multiple criteria for counting so use COUNTIFS.

In my first simple attempt, values in J cells are read as text and return 0. Converting values to numbers returns maximum and minimum.

Unfortunately, MINIFS() does not seem to be available with Excel 2010 Excel MINIFS function | Exceljet, same for COUNTIFS.

Explain the formula some more - why multiply by result of $H$9:$H$70=K1 ?


Wait, you want the count of values that have the least and most rows, not count of the maximum and minimum values? That changes everything for me. Back to square 1.