Results 1 to 15 of 15

Sumifs Formula with dates that change

Threaded View

tonym33 Sumifs Formula with dates... 05-15-2019, 03:58 PM
Melchizedek Re: Sumifs Formula with dates... 05-15-2019, 05:12 PM
tonym33 Re: Sumifs Formula with dates... 05-15-2019, 05:34 PM
TMS Re: Sumifs Formula with dates... 05-15-2019, 05:29 PM
TMS Re: Sumifs Formula with dates... 05-15-2019, 05:36 PM
tonym33 Re: Sumifs Formula with dates... 05-15-2019, 05:52 PM
TMS Re: Sumifs Formula with dates... 05-15-2019, 06:00 PM
Melvosh Re: Sumifs Formula with dates... 05-15-2019, 06:12 PM
tonym33 Re: Solved Sumifs Formula... 05-17-2019, 12:15 PM
Melvosh Re: Solved Sumifs Formula... 05-17-2019, 12:25 PM
tonym33 Re: Solved Sumifs Formula... 05-17-2019, 02:38 PM
AliGW Re: Solved Sumifs Formula... 05-17-2019, 12:28 PM
Melvosh Re: Sumifs Formula with dates... 05-17-2019, 02:45 PM
tonym33 Re: Sumifs Formula with dates... 05-17-2019, 04:01 PM
Melvosh Re: Sumifs Formula with dates... 05-17-2019, 04:26 PM
  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    Des Moines, Iowa
    MS-Off Ver
    Office 365
    Posts
    43

    Sumifs Formula with dates that change

    I have a sumifs formula with a date range that is working well. But I would like the formula to change based on the date. So if it's January I want it to pull January 1 thru January 31 and if it's March, March 1 thru March 31st. I have a table that has the dates in it, so is there a way that I can refer to that table and have it do the formula based on that table????

    This is an income statement. I can make the table work for YTD, but when I want only the month I have to do a range. What I can't figure out is how to make the range dynamic to change with the different dates without having to manually do this.

    Thanks
    Last edited by AliGW; 05-17-2019 at 12:28 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumifs formula with ingnoring the duplicates dates or shifts or so on
    By Naveenaggarwal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-19-2018, 03:20 AM
  2. Replies: 5
    Last Post: 03-30-2016, 06:01 AM
  3. [SOLVED] Formula to change dates
    By rizmomin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-13-2015, 12:33 PM
  4. sumifs formula for checking dates...
    By captnken in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-01-2014, 02:08 PM
  5. [SOLVED] SUMIFS formula not working with Dates
    By Bigred25 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2014, 10:25 AM
  6. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  7. [SOLVED] Using dates in SUMIFS formula
    By b.p.m in forum Excel General
    Replies: 2
    Last Post: 07-11-2012, 09:11 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