Question description:
This user has given permission to use the problem statement for this
blog.
I need help with a formula. I need the formula to read a date and return the data for the line and column. i also need it to return the sum of the column by week, by month, by year. I have the daily data worked out by changing the date in cell A2. I can not figure out the week, month , year sums.
Solved by K. D. in 39 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
31/07/2018 - 08:39
Hello
User
31/07/2018 - 08:39
hello
User
31/07/2018 - 08:39
Here is my Day formula
Excelchat Expert
31/07/2018 - 08:39
Can you provide your file or a sample of your data at the view
User
31/07/2018 - 08:40
=+(SUMIF(Table134[Column1],'Daily Production Report V2'!A2,Table134[Column2]))/B17
[Uploaded an Excel file]
User
31/07/2018 - 08:41
=+(SUMIF(Table134[Column1],'Daily Production Report V2'!A2,Table134[Column2]))/B17
User
31/07/2018 - 08:41
That is my Day formula
Excelchat Expert
31/07/2018 - 08:44
Can you send the file again please
Excelchat Expert
31/07/2018 - 08:45
I think there is a problem with the attachment
User
31/07/2018 - 08:46
yea maybe
User
31/07/2018 - 08:50
there
User
31/07/2018 - 08:51
Do you understnd what I am trying to do?
User
31/07/2018 - 08:52
I need F4 to calculate the week TD
Excelchat Expert
31/07/2018 - 08:52
Yes I think
Excelchat Expert
31/07/2018 - 08:53
F4 at which tap
User
31/07/2018 - 08:53
Based off of the date in A2
Excelchat Expert
31/07/2018 - 08:54
What is the week TD ??
User
31/07/2018 - 08:55
weed to date
User
31/07/2018 - 08:55
week*
Excelchat Expert
31/07/2018 - 08:56
So you want to get the total form sheet1 for the week end with the date at A2 ??
User
31/07/2018 - 08:56
yes
User
31/07/2018 - 08:57
A2 date -minus 7 days will be fine if that works
Excelchat Expert
31/07/2018 - 08:57
The total for column M Right ?
Excelchat Expert
31/07/2018 - 08:57
Yes I see
User
31/07/2018 - 08:58
No, each column on sheet1 is in column A
Excelchat Expert
31/07/2018 - 08:59
Column A is date
User
31/07/2018 - 08:59
See the data for Columns on main page is in B -L
User
31/07/2018 - 09:00
JR MR #1 SPL
Excelchat Expert
31/07/2018 - 09:00
I see it.
Excelchat Expert
31/07/2018 - 09:00
and the total is at column M
User
31/07/2018 - 09:01
I dont need the total for 1 day
User
31/07/2018 - 09:01
i need iot for the week for each column
Excelchat Expert
31/07/2018 - 09:01
Ok Ok
Excelchat Expert
31/07/2018 - 09:01
I understand you
User
31/07/2018 - 09:01
ok
Excelchat Expert
31/07/2018 - 09:02
give me 5 min to make the formulas
Excelchat Expert
31/07/2018 - 09:02
Ok
Excelchat Expert
31/07/2018 - 09:06
I'll put the formula at column F ( SMV) Ok
Excelchat Expert
31/07/2018 - 09:06
Or At column I ?
User
31/07/2018 - 09:06
yes
Excelchat Expert
31/07/2018 - 09:06
SMV ???
User
31/07/2018 - 09:06
each formula needs to match the correct column
User
31/07/2018 - 09:07
SMV is fine
Excelchat Expert
31/07/2018 - 09:07
Ok
Excelchat Expert
31/07/2018 - 09:12
[Uploaded an Excel file]
User
31/07/2018 - 09:13
I am looking now, thanks. I will see if they formulas will work on my sheet
Excelchat Expert
31/07/2018 - 09:13
OK
Excelchat Expert
31/07/2018 - 09:13
The formula is sumifs()
User
31/07/2018 - 09:15
does the P2 -7 give the last 7 days? is that this stipulation off the date?
Excelchat Expert
31/07/2018 - 09:15
Yes
User
31/07/2018 - 09:16
Perfect. so if i put -30 it would do the same thing?
Excelchat Expert
31/07/2018 - 09:16
the last 7 days including the current
Excelchat Expert
31/07/2018 - 09:16
Yes for the last month
User
31/07/2018 - 09:17
Thats what i need. I really thjank you alot. I have 47 hours invested on this workbook
User
31/07/2018 - 09:17
I wish we had more timei could share the whole thing its really a lot of data
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.