INDEX MATCH formula, ignore blank cells and define time frames

Hi!

I've read a few earlier posts to try and overcome the issue I'm having but with no success, so I'm a new member here.

I'm attempting to create a template for recorded data that's relevant to quality improvement. I've thus far managed to define some of the queries to be explored i.e., first data value for each row, whether that value was within a threshold, whether a value within the row's data range exceeded a threshold; however, I'm seriously struggling to define the values for the remaining queries I have (shown on the far right of the attachment)

What I'm hoping to receive help on is identifying whether a range fell below a value (unfortunately I've numerous errors trying to achieve this, especially as there are blank cells which need to be ignored but I'm uncertain how to include this in the formula; I've essentially attempted to use the opposite of the formula for identifying whether values within a range exceeded a threshold). Following this I need to determine whether it's possible to include time-frames (i.e. >2 days or >3 days) with these formulas too, adding further specificity to the analysis?

Thanks in advance

Thanks!

I've actually reverted to simply using a COUNTIF function for the thresholds. It's a little more convoluted I suppose but it works. Unfortunately, my greatest area of concern is identifying whether changes occurred after 48hours (2 consecutive cells) or 3 days (3 consecutive cells) - any advice?