averageifs issue

i’m encountering an issue with using the averageifs function.

i have a table in which i’m logging blood pressure and pulse per minute readings.

i have generated a pivot table, but pivot tables have formatting limitations, (can’t merge cells, delete columns/rows, and doesn’t adopt any existing user-applied formatting etc). so i’ve used a regular numbers table and the averageifs function which should yield the same results.

depending on the time the readings are taken (also logged) a formula generates "mor"(ning), "mid"(day), or "eve"(ning) in a column to indicate the ‘period’ in the day when reading is taken. each period involves several readings.

i then derive averages for periods, and overall daily averages.

i created the first row of formulae for the morning period block of three columns (systolic, diastolic and pulse readings), which generates the averages from several morning period readings.

in the formula i have preserved columns/ rows as required to ensure the date/period conditions are looked up at the right place in the averages table.

copying the formulae down the rows for a date i encounter a problem. the formula error bar for each of the systolic, diastolic and pulse averages columns indicate you cannot divide a number by zero.

oddly, the second row of the table shows the exclamation error indicator, but the third row doesn’t. as i don’t have data for beyond the third row, all the subsequent rows show errors, which may change once i have dates for later dates. i

i generally use iferror to mask ‘no data’ errors, but until i resolve the issue arising, i won’t be.

any ideas on what the issue could be, or has anyone encountered this?

i’ve also recreated the formula from scratch on the second row and i still get the error, so for consistency copied the formula down again for the two photos below of the formula on the first and second rows of the table.

i’m using a 1st gen ipad pro.