Question description:
This user has given permission to use the problem statement for this
blog.
I was jut receiving help from a spreadsheet expert. He/She was able to create the right formula in cell F2, but now I'd like to figure out how to easily take that formula across column 2 without having to type in date and time criteria for each cell.
Solved by I. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/05/2017 - 06:10
Hi, It's my pleasure to help you today!.
User
22/05/2017 - 06:11
ok thanks - I'm wondering if the same person is available bc they can still work on it
Excelchat Expert
22/05/2017 - 06:11
Can you please provide me the sheet to work on.
User
22/05/2017 - 06:11
they were getting close to figuring it out
User
22/05/2017 - 06:11
https://docs.google.com/spreadsheets/d/1ARRVOzgE16AYgMlsfcTdi_doJzvfEzSSEuoI1Wsl6uQ/edit#gid=627794731
Excelchat Expert
22/05/2017 - 06:12
Hi, I am interacting with you first time. I am taking look at it.
User
22/05/2017 - 06:12
okay but someone else is still working on it
User
22/05/2017 - 06:12
they were close to figuring it out
User
22/05/2017 - 06:12
we just ran out of time, so I need to purchase another session
Excelchat Expert
22/05/2017 - 06:12
At present, all experts are in sessions. I am the only one interacting with you.
User
22/05/2017 - 06:13
ok
Excelchat Expert
22/05/2017 - 06:13
I can work on it. Please let me know your requirement.
User
22/05/2017 - 06:13
the previous expert was able to put the right formula into cell F2 on the tab titled SF - Fulfillment Manifest
Excelchat Expert
22/05/2017 - 06:13
Ok. I am at that location.
User
22/05/2017 - 06:14
however, I'd now like to copy that formula indefinitely across row 3
Excelchat Expert
22/05/2017 - 06:14
Whether the result is correct as expected?
User
22/05/2017 - 06:14
the criteria is for Monday: ll orders placed between the previous Wednesday at 6:01 am and Monday at 6:00 am
User
22/05/2017 - 06:14
sum the quantity of orders placed
Excelchat Expert
22/05/2017 - 06:14
Ok.
User
22/05/2017 - 06:14
or Wednesday: all orders placed between the previous Monday at 6:01 am and Wednesday at 6:00 am.
User
22/05/2017 - 06:15
the formula is right in F3, but I don't want to have to manual input it across the dates
Excelchat Expert
22/05/2017 - 06:15
I think, the formulas are already avaialble
User
22/05/2017 - 06:15
I'm wondering if there is an easy way to look at it
Excelchat Expert
22/05/2017 - 06:15
Ok. Great.
Excelchat Expert
22/05/2017 - 06:15
I am checking it.
Excelchat Expert
22/05/2017 - 06:17
Ok. I got it.
Excelchat Expert
22/05/2017 - 06:17
I am trying to find a different formula to get as required.
Excelchat Expert
22/05/2017 - 06:20
Ok. Now, i have updated the formulas for F3
Excelchat Expert
22/05/2017 - 06:21
And H3 is same as previous one.
User
22/05/2017 - 06:21
ok
Excelchat Expert
22/05/2017 - 06:22
There should be a different in formulas for F3 and H3. As there is a date range difference.
Excelchat Expert
22/05/2017 - 06:23
It looks like there is no data to calculate for Column O to V
Excelchat Expert
22/05/2017 - 06:24
Otherwise, i have updated the formula
User
22/05/2017 - 06:24
yes that is correct
Excelchat Expert
22/05/2017 - 06:24
The problem is solved :)
User
22/05/2017 - 06:24
so if I add more dates can I drag the formula over
Excelchat Expert
22/05/2017 - 06:24
You can copy the set of 2 formulas (monday + wednesday)
User
22/05/2017 - 06:24
awesome
Excelchat Expert
22/05/2017 - 06:24
As there are gaps between 2 rows.
User
22/05/2017 - 06:25
and I see you've already copied it down
Excelchat Expert
22/05/2017 - 06:25
Yes. I did
Excelchat Expert
22/05/2017 - 06:25
So glad to hear that! Please come back to Excel Chat for any you spreadsheet problems. Also, please have a wonderful day! Thank you!
User
22/05/2017 - 06:25
I'm only going to do Monday and Wednesday in row 1
User
22/05/2017 - 06:25
I'll delete the other dates
User
22/05/2017 - 06:25
will that mess up formula
Excelchat Expert
22/05/2017 - 06:26
Is it 5 days back or 7 days back.
User
22/05/2017 - 06:27
On Monday, the staff Roasts and Fulfills for all orders placed between the previous Wednesday at 6:01 am and Monday at 6:00 am On Wednesday, the staff Roasts and Fulfills for all orders placed between the previous Monday at 6:01 am and Wednesday at 6:00 am.
Excelchat Expert
22/05/2017 - 06:27
Ok. I have updated the formula
Excelchat Expert
22/05/2017 - 06:28
I have used 5 days back.
User
22/05/2017 - 06:28
awesome
User
22/05/2017 - 06:28
s!
User
22/05/2017 - 06:29
thanks!
Excelchat Expert
22/05/2017 - 06:29
You may now close this chat. Please leave a 5-star rating after ending the session:)
User
22/05/2017 - 06:29
will do