Filtered List Formula

[aoifew]

Hi
I’m attempting to create an array formula that only picks upvalues in a filtered list. Is itpossible to combine both formulae
Array formula:
=(SUM(IFERROR((AK5:AK215<(TODAY()))*(AK5:AK215<>""),0))) (courtesyof Jasonb75)

Picks up non-blanks with the filtered list:
SUBTOTAL(102,AK5:AK215)

Please note, the column that is the filter is applied to isn’talways adjacent to the AK column
Cheers

 

[aoifew]

To help clarify by using the example in the link, I’d liketo filter the columns H to L separately by removing blanks.
For example, if Filter List 1 (Column H) is filtered toremove blanks, I’d like the formula in cell D13 to reflect that there are nolonger reds in the column D range.
In more refined example, I hide columns so that in theexample given, only columns C, D and H are visible. There are numerous other employee names, numerousother job titles (ie filter lists) plus new names/job titles will be added infuture.
Is it possible to achieve this?
https://www.dropbox.com/s/bgdzp3yzobesfd7/Sample.xlsx?dl=0