+ Reply to Thread
Results 1 to 2 of 2

Subtotal Array

  1. #1
    Registered User
    Join Date
    01-15-2013
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    95

    Subtotal Array

    I have an issue where my subtotal array formula isn't working. However, when I just regular Max(IF.... it works just fine. Was wondering if anyone has an idea of why it's giving me just a #Value error.

    Here's my formula =SUBTOTAL(104,(IF(TBL_Tasks[Phase]=[@Phase],TBL_Tasks[Days to Complete],0))) and it's an array so ctrl+shift+enter

    I've also attached a sample file. Hopefully someone can help. Thanks in advance..
    sample1.xlsm

  2. #2
    Registered User
    Join Date
    01-15-2013
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    95

    Re: Subtotal Array

    Figured it out. This formula worked....

    {=MAX(SUBTOTAL(104,OFFSET(C$10,ROW(C$10:C$15)-ROW(C$10),,1))*(D$10:D$15=[@Phase]))}


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1