+ Reply to Thread
Results 1 to 6 of 6

Dynamic MultiColumn SumIF Formula

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    East Coast
    MS-Off Ver
    2013
    Posts
    69

    Dynamic MultiColumn SumIF Formula

    All,

    I'm having trouble with the following (see attached for example problem). I'd like to write a "sumifs-like" formula that can accommodate a multi-column sumrange based upon today's date and month.

    For example, if sumifs criteria are met, the formula would sum column 1 through column x (column x's header would be today's month and fiscal year).

    Any ideas? The example workbook should provide a more clear description of the problem.

    Thanks in advance!
    Attached Files Attached Files
    Last edited by ChrisHook; 03-10-2019 at 05:17 PM. Reason: adding attachment

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: Dynamic MultiColumn SumIF Formula

    It's almost always easier and simpler to use actual dates rather than text dates.

    With that thought in mind in E14 enter 10/1/2018 for the start date. In F14 and across
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Use those for column referencing.

    There is no APE # in D6. This formula does not explicitly include the APE #s. Add another criteria to this formula if that changes.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Registered User
    Join Date
    10-14-2015
    Location
    East Coast
    MS-Off Ver
    2013
    Posts
    69

    Re: Dynamic MultiColumn SumIF Formula

    Hey FlameRetired,

    Thanks for the quick response. Although, it seems as if the formula you provided sums every column, instead of summing just through the date in cell A2 (assuming i translated your formula correctly to the attached).
    Attached Files Attached Files

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: Dynamic MultiColumn SumIF Formula

    Try changing the date in E14 to 10/1/2018

  5. #5
    Registered User
    Join Date
    10-14-2015
    Location
    East Coast
    MS-Off Ver
    2013
    Posts
    69

    Re: Dynamic MultiColumn SumIF Formula

    Doh! Works like a charm. Many thanks

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2301, rarely Office 2007
    Posts
    12,887

    Re: Dynamic MultiColumn SumIF Formula

    You are welcome. Glad to help. Thank you for the feedback and marking your thread Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamic Cell Range within SUMPRODUCT/SUMIF formula
    By regoroes in forum Excel General
    Replies: 8
    Last Post: 12-23-2017, 03:25 AM
  2. [SOLVED] Dynamic sumif formula
    By j2mbs1655 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-30-2015, 09:48 AM
  3. [SOLVED] Dynamic MultiColumn Conditional Format
    By ClickitySplit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2014, 01:21 PM
  4. Multicolumn dynamic Listbox - Remove Duplicates in Listbox
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2014, 12:30 PM
  5. Dynamic SUMIF formula help please
    By j2mbs1655 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2013, 02:26 PM
  6. make a sumif formula dynamic
    By amartino44 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-08-2013, 11:19 AM
  7. [SOLVED] SUMIF formula with dynamic column? HLOOKUP?
    By jrvstl in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-01-2012, 12:04 AM

Tags for this Thread

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