Like pulling teeth but I think I have it.
Excel quite reasonably assumes the relevant data does not cross a blank row. It would be correct in most cases.
In this case you have to change the equation to include the rows above the blank one.




*******************
Consider rating the thread by going to the "Rate Thread" dropdown.