Filtered List Formula

aoifew

New Member
Joined
Jun 23, 2019
Messages
18
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
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

aoifew

New Member
Joined
Jun 23, 2019
Messages
18
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
 

Forum statistics

Threads
1,089,220
Messages
5,406,937
Members
403,113
Latest member
ms_excel_recal_or_die

This Week's Hot Topics

Top