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