Date range with cell totals to another sheet

[dmed99]

Hi,

Trying to figure out an easy way to take our sales totals from last year and have then input into a cell pending the month that we are in. So for instance, we are currently in January, so I need January 16 to show in the is cell and have January 16 to show into a different cell. Now we are a couple days away from February then I would like it to change to the February numbers.

I have added 2 excel sheets for demo. The "2017 Goal Mock" is that data that I would like to pull over to the "Goal Sheet Mock". I have "X's" marked on the Goal where I want the data to be displayed depending on which month it is, ie. February C6 would show $104,000 on the "Goal Sheet" J4 and N6 would show on the "Goal Sheet" J6. I would like this happen automatically.

Not sure if this is possible at all.

Thanks for you help in advance.

Dan

[AliGW]

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[dmed99]

AliGW,

I have completed what you have asked. Hopefully this will help.

Dan

[avk]

if your data in Sheet1! : column "A" is Date & "B" is Sales Amount
In Sheet2! : column "A" is Start Date, column "B" is End Date,
In column "C" formula.

=SUMIFS(Sheet1!$B$2:$B$61,Sheet1!$A$2:$A$61,">="&$A2,Sheet1!$A$2:$A$61,"<="&$B2)

Note : In sheet2! you can change data as per your requirment. (in column "A" & "B", Start & End Date respectively)

[avk]

Refer attach file.
I have done some modification in data structures. In your file remove unwanted empty columns/rows. Empty columns/rows not a good practice.
In File 2017 Goals Mock : Mentioned in columns "A" & "H" month & year.
In File Goad Sheet Mock : In Cell "D1" & "D3" is select required month (DataValidationList)
In "C1" & "C3" is formula (INDEX/MATCH)

[dmed99]

I cannot see you attached files. When I go to download they are coming acrossed in php not xlsx.

[avk]

Please refer. I once again attach excel file.
https://www.stellarinfo.com/support/...-filename-xlsx

https://support.mozilla.org/en-US/questions/1052979

[dmed99]

Thanks for your help.

Solved