Results 1 to 2 of 2

Thread: Filtered List Formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Filtered List Formula

    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

  2. #2
    New Member
    Join Date
    Jun 2019
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filtered List Formula

    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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •