Offset with CountA subtotal Not counting bottom rows or blanks

Hello,

I'm working with a workbook that contains 2 reports Submissions and Resubmissions. I need to count those that are late (which is a filter, so I'm using a subtotal) by company and contact. Each company can have several contacts. It appears the last row before filtered data is being ignored ie rows 6-10 aren't shown due to the filter and row 5 isn't being counted

For submissions I'm using:

Formula:

Please Login or Register  to view this content.

The current iteration of the report has a total of 173 late submissions. But using this equation, I only get 172 and the last row is always ignored.

For resubmissions I'm using:

Formula:

Please Login or Register  to view this content.

This sheet contains 145 late resubmissions and the formula only returns 141 where blanks are being ignored and random other values are