Subtotal for countifs function

Hi,

My employees are rewarded for their sales once the product has been delivered.
Every sale has a row with the salesman's name (Column B) and the status of the product (sold, delivered, canceled...) (Column N)
The formula on cell "N46"
=COUNTIFS(N5:N44,"=Delivered")
Is there any way to use the subtotal function in order to get the countifs number once filtered by salesman name?

The simplest way is to insert a helper column, e.g. in Z5 copied down

=SUBTOTAL(3,N5)

That formula will always show 1 on visible rows (assuming you always have column N populated) so then you can use a SUMIF formula for visible rows only

=SUMIIF(N5:N44,"Delivered",Z5:Z44)