+ Reply to Thread
Results 1 to 5 of 5

Formula to sum ranges based on criteria with sum range moving based on date criteria

  1. #1
    Registered User
    Join Date
    04-19-2022
    Location
    Bristol, England
    MS-Off Ver
    Professional Plus 2021
    Posts
    21

    Formula to sum ranges based on criteria with sum range moving based on date criteria

    Hi all,

    I have income and expenditure data which is listed by days. I need to pull this data into another tab and group weekly (by end of week). so I need a formula that sumifs by income/expenditure type if the date falls between the end of the week and the beginning of the week.

    I have attached a file with example data. I need the formula in Sheet 1 tab in D13:N21 and D26:N35 based on the data in the bank tab. So D14 is Reg fees for week ending 3/9/23 and that should total £600 and E14 should equal £1,200.

    Thanks in advance.

    James
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,451

    Re: Formula to sum ranges based on criteria with sum range moving based on date criteria

    Hi,

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and copied to the rest of your table should give the results that you want.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,501

    Re: Formula to sum ranges based on criteria with sum range moving based on date criteria

    Another way in D14

    Please Login or Register  to view this content.
    copied down and across.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-19-2022
    Location
    Bristol, England
    MS-Off Ver
    Professional Plus 2021
    Posts
    21

    Re: Formula to sum ranges based on criteria with sum range moving based on date criteria

    Great, thank you that worked. Much appreciated.

  5. #5
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,501

    Re: Formula to sum ranges based on criteria with sum range moving based on date criteria

    You are welcome.

+ 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. Replies: 1
    Last Post: 04-09-2021, 11:09 AM
  2. [SOLVED] Formula to pull the MIN date from a range, based on the criteria.
    By Budhdr in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-11-2018, 10:44 AM
  3. [SOLVED] IF/AND formula issue-Assiging date within range based on 1 criteria
    By hopegriffin in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-11-2016, 05:11 PM
  4. Formula to return values based on criteria and date range
    By jr217 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2014, 06:20 AM
  5. [SOLVED] Moving data to a different worksheet based on date criteria
    By smlon2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2014, 02:32 AM
  6. Formula for copying a entire row based on a date range criteria.
    By workallday in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2012, 01:09 AM
  7. Moving rows of data to a new sheet based on date criteria
    By kaufmann98 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2012, 01:41 PM

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