+ Reply to Thread
Results 1 to 6 of 6

Enter Value of cell within a date range

  1. #1
    Registered User
    Join Date
    09-02-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    10

    Enter Value of cell within a date range

    This maybe a little difficult to explain. I have a spreadsheet that contains data from sales being made in various locations (sheet 1). The date the sale was made is in column A, and the location is in column AZ. I may have from 0 to 12 sales at that location on the same date. I am building a report in another sheet (sheet 2) that counts the number of sales for each date and displays that number in a cell in row 3. Above row 3, I want a formula that will reference the location (AZ sheet 1) and display that into my cell above row 3 in sheet 2. Each column in row 1 sheet 2 will have new date. I am sure this is pretty easy but I can't find anything that works. I hope someone can help me please!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Enter Value of cell within a date range

    I am a little unclear as to what you want, sorry

    I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Enter Value of cell within a date range

    Hi,

    could you upload a sample file in order to focus layout of your data?

    Probably you a COUNTIF or a SUMPRODUCT

    An example

    in Sheet2 in A1 a date to match to A4:A100 dates in sheet1 in order to count (not sum) sales.

    Please Login or Register  to view this content.
    Regards


    edit: sorry FDibbins, I did not mean to overlap: I 'm a very slow writer
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  4. #4
    Registered User
    Join Date
    09-02-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Enter Value of cell within a date range

    I attached a test sheet, on sheet 1 cell B3 you can see the formula I entered. It works in cell B3 but when I drag it across it doesn't work. I need it to work in the entire row. I hope this helps and thank you for your responses.

    Keith
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Enter Value of cell within a date range

    Hi,

    not sure, in B3 you could try

    Please Login or Register  to view this content.
    Regards

  6. #6
    Registered User
    Join Date
    09-02-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Enter Value of cell within a date range

    Thank you CANAPONE that did the trick!! It is so great to have others help out!

+ 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. Replies: 7
    Last Post: 09-17-2013, 03:42 PM
  2. Replies: 4
    Last Post: 05-01-2013, 07:38 PM
  3. Enter Date Range in Userform and Retrieve corresponding information
    By raffajoaqim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 05:44 PM
  4. Enter custom date range to show data
    By ericbsandiego in forum Excel General
    Replies: 4
    Last Post: 12-11-2008, 01:56 PM
  5. [SOLVED] How do I enter a date range ie -7 from current date in MS QUERY
    By notsmartenough in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 06: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1