Enter Value of cell within a date range

**keithnrhonda** · 11-21-2013, 12:48 AM

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!

**FDibbins** · 11-21-2013, 01:50 AM

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.

**canapone** · 11-21-2013, 01:58 AM

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

**keithnrhonda** · 11-21-2013, 03:48 AM

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

**canapone** · 11-21-2013, 04:09 AM

Hi,

not sure, in B3 you could try

Please Login or Register  to view this content.

Regards

**keithnrhonda** · 11-21-2013, 12:34 PM

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

Enter Value of cell within a date range

LinkBack

Thread Tools

Rate This Thread

Display

Enter Value of cell within a date range

Re: Enter Value of cell within a date range

Re: Enter Value of cell within a date range

Re: Enter Value of cell within a date range

Re: Enter Value of cell within a date range

Re: Enter Value of cell within a date range

Thread Information

Users Browsing this Thread

Similar Threads

if a range of celll eg b1 to b20 90.1 enter and and cell range c1 to c20 ok then change

How do I lock the date when I enter data to highlight a cell dependent on that date?

Enter Date Range in Userform and Retrieve corresponding information

Enter custom date range to show data

How do I enter a date range ie -7 from current date in MS QUERY

Bookmarks

Bookmarks

Posting Permissions