**Question description:**

*This user has given permission to use the problem statement for this blog.*

I know how to make a forumal change weekly with fixed numbers but how do you make it change with numbers that change weekly? For example: =8*'sheetname'!$A$1
What if the 8 wasn't the same every week?

Solved by Z. U. in 28 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
08/03/2018 - 09:15

Hi welcome to Gotit

Excelchat Expert
08/03/2018 - 09:15

hello

Excelchat Expert
08/03/2018 - 09:16

please share your sheet

User
08/03/2018 - 09:16

I have a spreadsheet that reads formulas week to week for fixed goals....I want to use a similar formula for actual production week to week as well

User
08/03/2018 - 09:16

I dont have a sheet yet

Excelchat Expert
08/03/2018 - 09:17

Please provide example data

User
08/03/2018 - 09:19

Calls needed will be the same every week....100

User
08/03/2018 - 09:19

Calls made will change every week...25

Excelchat Expert
08/03/2018 - 09:19

ok

User
08/03/2018 - 09:19

How do I keep a running tally of E10 week to week

Excelchat Expert
08/03/2018 - 09:20

you need E10 value of every week?

User
08/03/2018 - 09:20

without manually doing it

User
08/03/2018 - 09:20

yes but I need c10 to constantly add 100 each week and not include weeks that havent occurred yet

Excelchat Expert
08/03/2018 - 09:20

Here we can write a formula for individual weeks

Excelchat Expert
08/03/2018 - 09:21

So you can compare individual week percentages

Excelchat Expert
08/03/2018 - 09:21

See E3 and E5

User
08/03/2018 - 09:22

i see that..understand that

Excelchat Expert
08/03/2018 - 09:22

so you can have a look on individual weeks

User
08/03/2018 - 09:23

how do I make c10 and d10 automatically include new weeks without adding weeks that have not occured yet

Excelchat Expert
08/03/2018 - 09:23

E10 is basically gives you average of week 2 and 3

User
08/03/2018 - 09:23

i dont want 3/15 added yet but I will when 3/16 day is here

Excelchat Expert
08/03/2018 - 09:24

I didn't get you

User
08/03/2018 - 09:24

c7 and c8

Excelchat Expert
08/03/2018 - 09:24

yes

User
08/03/2018 - 09:24

those dates havent happened yet but I know what the goal is

User
08/03/2018 - 09:24

when 3/17 is here how does c10 automatically calculate c7 and c8 now that they are in the past

User
08/03/2018 - 09:25

so on 3/18 c10 should be 400

Excelchat Expert
08/03/2018 - 09:26

So C10 should automaticall calculate the added weeks right

Excelchat Expert
08/03/2018 - 09:26

that is what you are saying?

User
08/03/2018 - 09:26

but only for the data that is int eh past

User
08/03/2018 - 09:26

is in the past

User
08/03/2018 - 09:27

i currently have to go into c10 and add c7 and c8 manually for all individuals

Excelchat Expert
08/03/2018 - 09:27

C10 should calculate only past data not future

User
08/03/2018 - 09:27

how do you do that?

User
08/03/2018 - 09:27

c10 currently has 400

User
08/03/2018 - 09:27

shold read 200

Excelchat Expert
08/03/2018 - 09:28

So you want only past data not future data to be added right?

User
08/03/2018 - 09:28

yes

Excelchat Expert
08/03/2018 - 09:29

Give me 5 minutes

Excelchat Expert
08/03/2018 - 09:34

Please check now

Excelchat Expert
08/03/2018 - 09:35

I added formula C3 to C9 and check how E10 changes

Excelchat Expert
08/03/2018 - 09:35

hello

Excelchat Expert
08/03/2018 - 09:35

are you there?

Excelchat Expert
08/03/2018 - 09:35

Hey

User
08/03/2018 - 09:35

yes

Excelchat Expert
08/03/2018 - 09:35

Are you there?

Excelchat Expert
08/03/2018 - 09:35

Please check

User
08/03/2018 - 09:35

what is that? lol

Excelchat Expert
08/03/2018 - 09:36

Change 16 mar to past date

User
08/03/2018 - 09:36

yes!!

Excelchat Expert
08/03/2018 - 09:36

E10 changed right?

Excelchat Expert
08/03/2018 - 09:36

Change it to future date

Excelchat Expert
08/03/2018 - 09:36

and check

User
08/03/2018 - 09:36

yes...how?

Excelchat Expert
08/03/2018 - 09:36

is that working?

User
08/03/2018 - 09:37

that is what I need

Excelchat Expert
08/03/2018 - 09:37

In F1 you can see today formula right?

User
08/03/2018 - 09:37

so just change f1?

Excelchat Expert
08/03/2018 - 09:37

no

Excelchat Expert
08/03/2018 - 09:37

in B10 I wrote a formula

User
08/03/2018 - 09:38

I see the formula...what is the < referncing?

Excelchat Expert
08/03/2018 - 09:38

it will compare the dates with today and add if date is less than are equal to today

Excelchat Expert
08/03/2018 - 09:39

because future days will be greater than todays

User
08/03/2018 - 09:39

how does it know current date?

Excelchat Expert
08/03/2018 - 09:39

Got the logic which I used?

Excelchat Expert
08/03/2018 - 09:39

F1 is have a function called today

Excelchat Expert
08/03/2018 - 09:39

today will return current date

User
08/03/2018 - 09:39

F1 = today?

Excelchat Expert
08/03/2018 - 09:39

yes

User
08/03/2018 - 09:39

shoot...didnt know that!

Excelchat Expert
08/03/2018 - 09:40

Go to F1 cell

Excelchat Expert
08/03/2018 - 09:40

you will see a fucntion =Today() which will return current date

Excelchat Expert
08/03/2018 - 09:40

Gotit ?

User
08/03/2018 - 09:40

that is confusing

User
08/03/2018 - 09:41

I think I get it

User
08/03/2018 - 09:41

put what I have to put back in f1

Excelchat Expert
08/03/2018 - 09:41

=Today()

User
08/03/2018 - 09:42

so it autmotically puts next day

Excelchat Expert
08/03/2018 - 09:42

yeah tomorrow it changes to 10 automatically

Excelchat Expert
08/03/2018 - 09:42

Note I made formula only for calls need column

Excelchat Expert
08/03/2018 - 09:43

Make changes for other cells using the same formula

Excelchat Expert
08/03/2018 - 09:43

and please end the session

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