+ Reply to Thread
Results 1 to 3 of 3

How to sum the values between two dates by selecting one date from drop down list

  1. 10-10-2014, 07:21 AM #1
    atif574
    atif574 is offline
    Registered User
    Join Date
    01-09-2014
    Location
    lahore,pakistan
    MS-Off Ver
    Excel 2010
    Posts
    34

    How to sum the values between two dates by selecting one date from drop down list

    Respected Concern,

    I want to make a sheet for the comparison between current year and previous year. For the better understanding, i am going to attach workbook.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-10-2014, 07:33 AM #2
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: How to sum the values between two dates by selecting one date from drop down list

    Try

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


    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  3. 10-10-2014, 07:38 AM #3
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How to sum the values between two dates by selecting one date from drop down list

    Try

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

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

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    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. [SOLVED] Forumla IF Help - Compare list of dates with date and values
    By caf20012 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2013, 11:44 AM
  2. [SOLVED] Selecting date from the drop down list without using help of other sheet / data validation
    By skhari in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-17-2012, 04:40 PM
  3. Choosing a worksheet with drop down list then selecting data with another drop down list
    By MTAZ in forum Excel General
    Replies: 3
    Last Post: 04-16-2012, 10:14 PM
  4. Sumproduct selecting dates betwee two date values
    By Nelis in forum Excel General
    Replies: 2
    Last Post: 03-29-2010, 11:04 AM
  5. [SOLVED] How to make drop-down list of dates start with current date?
    By Jan Buckley in forum Excel General
    Replies: 15
    Last Post: 08-29-2005, 05:05 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