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:

=SUMPRODUCT(('Submission'!$B$1:$B$3500=A47)*('Submission'!$C$1:$C$3500=B47)*SUBTOTAL(103,OFFSET('Submission'!$A$1,ROW('Submission'!!$A$1:$A$3500),0,1))) 

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:

=SUMPRODUCT(('Resubmissions'!$K$3:$K$3500=A3)*('Resubmissions'!$O$3:$O$3500=B3)*SUBTOTAL(103,OFFSET('Resubmissions'!$A$1,ROW('Resubmissions'!$A$3:$A$3500),0,1)))

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