Results 1 to 10 of 10

SUMIFS Date Ranges

Threaded View

  1. #1
    Banned User!
    Join Date
    08-14-2019
    Location
    UK
    MS-Off Ver
    2010
    Posts
    72

    SUMIFS Date Ranges

    Original Message (reinstated by moderator):
    Hi,

    I need to get the totals for due dates within a week, 2 weeks, 3 weeks, and 4 weeks. This should be in reference to today's date but I'm not sure how to get the formulas.

    This is on the Status sheet in cells E5:E8

    Can someone please help?
    I will put solution later

    Thanks
    Last edited by AliGW; 08-16-2019 at 03:20 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIFS with Date ranges getting #VALUE!
    By HeadSkrach in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-22-2016, 05:31 PM
  2. [SOLVED] SUMIFS Help - Multiple date ranges
    By dspblues in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-18-2014, 07:38 AM
  3. Weighted average based on various date ranges (SUMIFS or SUMPRODUCT)?
    By MajorMattMason in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-14-2014, 09:34 PM
  4. [SOLVED] SUMIFS with time and date name ranges
    By tradersumit in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2012, 07:47 AM
  5. Excel 2007 : Using SUMIFS and date ranges...
    By anthropaulogy in forum Excel General
    Replies: 3
    Last Post: 09-06-2012, 07:05 AM
  6. Sumifs Using Date Ranges
    By Loisw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2012, 07:43 AM
  7. How to use SUMIFS when using two different date ranges
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2011, 07:30 PM

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