Excel - COLUMN Function Problem - Expert Solution

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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.