+ Reply to Thread
Results 1 to 4 of 4

Sumifs formula to extract values based on date range

  1. 12-23-2020, 01:16 AM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,732

    Sumifs formula to extract values based on date range

    I have tried to set up sumifs formula to extract values based on a range of dates for a particular month for eg from 01/03/2020 to 31/03/2020 for all values pertaining to March 2020


    However, my formula returns zero


    Kindly check and amend my formula
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-23-2020, 01:22 AM #2
    Crooza
    Crooza is offline
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Sumifs formula to extract values based on date range

    Try this in E2 and drag down
    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below
    Reply With QuoteRegister To Reply
  3. 12-23-2020, 02:00 AM #3
    Shareez Saleem
    Shareez Saleem is offline
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    696

    Re: Sumifs formula to extract values based on date range

    Alternative formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 12-23-2020, 02:17 AM #4
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,732

    Re: Sumifs formula to extract values based on date range

    Hi Crooza & Shareez

    Many thanks for the help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to extract a value based on a client code match AND that fits within a date range
    By Chiwidan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2020, 09:24 AM
  2. [SOLVED] Macro to extract data based on date range and values
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 36
    Last Post: 05-08-2020, 10:44 AM
  3. [SOLVED] Sumifs to compute values in Date Range
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-04-2020, 12:40 AM
  4. [SOLVED] How to extract sumifs data based on date
    By arsyan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2019, 12:28 PM
  5. [SOLVED] sumifs formula to extract first left item based on Crteria
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2019, 01:20 AM
  6. [SOLVED] Date Range Based Sumifs...
    By lifeisaspreadsheet in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-18-2012, 02:06 PM
  7. Need help with SUMIFS based on a date range
    By leopardhawk in forum Excel General
    Replies: 3
    Last Post: 02-05-2011, 01:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1