Well hush ma' mouth ...
Nice one mama ..
A word of caution, you can't simply extend the formulae depth by extending the ranges to safely cover your expected largest list of data.
The formulae must cover the exact size of the list, any blank rows at the end of the table, or blanks in the serial codes, will cause the formulae to fail.
To allow for this might I suggest you still use the dynamic names I suggested earlier.
e.g.
Formula:
=SUM(SIGN(FREQUENCY(IF((Temp_In<125)+(Temp_Out<125)>0,MATCH(SerialCode,SerialCode,0)),MATCH(SerialCode,SerialCode,0))))
I have added mamas' solution to this workbook (the orange cells)
Bookmarks