+ Reply to Thread
Results 1 to 3 of 3

Get total from a Date to a Date

  1. #1
    Registered User
    Join Date
    06-24-2014
    Location
    Maldives
    MS-Off Ver
    2013
    Posts
    23

    Get total from a Date to a Date

    Hi,
    I am trying to make total sales of canteen for specific dates.
    For example: I want to get the total sales done from 22 January 2017 to 31 January 2017.
    And if you could it will be very helpful when the item is selected in cell B, the items received, sold and rate must come in cell E, F & G.
    When I select the dates and the items it should come.
    If there is any way to do this, please tell me.
    If you need any more explanation, please tell me.
    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Get total from a Date to a Date

    okay Try

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


    Drag it in F column and down.

    Now in sheet Faisaa Havvalkuraa

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

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

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


    Then

    G5
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and drag down.

    Check the attached file.

    Hope it will help you.
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    06-24-2014
    Location
    Maldives
    MS-Off Ver
    2013
    Posts
    23

    Re: Get total from a Date to a Date

    Thank u
    This was really helpful.

+ 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. Date and data lookup to total within a date range
    By greg123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2016, 03:09 AM
  2. Replies: 8
    Last Post: 12-20-2015, 11:46 PM
  3. Replies: 24
    Last Post: 10-08-2014, 10:31 AM
  4. Replies: 0
    Last Post: 01-28-2014, 07:37 AM
  5. Replies: 2
    Last Post: 10-06-2013, 02:03 PM
  6. to-date total based on current date
    By dreamkeeper in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-09-2006, 11:04 AM
  7. running total by date (not sorted by date though...)
    By rainxking in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2006, 09:01 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