C
Calvin
OK this is a doosy, so this may take some time to explain. First I hav
a sheet with buy and sell prices. This sheet calculate daily which the
calculates weekly and finally to a monthly total. The problem is/are o
that single sheet all the calculation work as planned, but after mov
on to the next week by using a copy sheet my weekly figures ar
condensed (totaled) into one cell. ie
weekDay()
MON $100 =19
TUE $200 =20
WED $100 =21
THU $300 =22
FRI $200 =23
WEEK 1 if weekday <7 then total...
WEEK 2 if weekday is >=8 and <=14 then total
WEEK 3 if weekday is >=15 and <=21 then total
WEEK 4 if weekday is >=22 and <=28 then total
WEEK 5 if weekday is >=29 and <=31 then total
JAN
FEB....you get the picture.
The way I have done this is to create a timestamp when the dolla
figure is entered and the time stamp is formated to only display th
weekday. I the wrote a IF statement that looks like this:
=IF($B$2>0,$N86,IF($K86>=$N86,$K86,0))
B2 represent a value that is always going to be above 0 until a ne
sheet is started.
N86 is were I am getting a full (or to date) total from.
K86 is the cell I am using of which the last part of the statemen
freezes the total in the in the cell no matter what (or so I thought).
In a simple equation A+B=C unless A and B are changed to 0, which the
it says before you go to a 0 value take C and put it in D.
IF(A1>0,C1,IF(D1>=C1,D1,0))
well this works until I copy sheets. then what is in week 3 is added t
week four. Thats problem 1. of which I can some what live with, but
would like it to work
The second part of that is (example) I am left with week four totas an
ready to start a new week on a new sheet. as soon a there is any dat
entered the total for week 4 disappears. How can I keep that data an
add to that tota
a sheet with buy and sell prices. This sheet calculate daily which the
calculates weekly and finally to a monthly total. The problem is/are o
that single sheet all the calculation work as planned, but after mov
on to the next week by using a copy sheet my weekly figures ar
condensed (totaled) into one cell. ie
weekDay()
MON $100 =19
TUE $200 =20
WED $100 =21
THU $300 =22
FRI $200 =23
WEEK 1 if weekday <7 then total...
WEEK 2 if weekday is >=8 and <=14 then total
WEEK 3 if weekday is >=15 and <=21 then total
WEEK 4 if weekday is >=22 and <=28 then total
WEEK 5 if weekday is >=29 and <=31 then total
JAN
FEB....you get the picture.
The way I have done this is to create a timestamp when the dolla
figure is entered and the time stamp is formated to only display th
weekday. I the wrote a IF statement that looks like this:
=IF($B$2>0,$N86,IF($K86>=$N86,$K86,0))
B2 represent a value that is always going to be above 0 until a ne
sheet is started.
N86 is were I am getting a full (or to date) total from.
K86 is the cell I am using of which the last part of the statemen
freezes the total in the in the cell no matter what (or so I thought).
In a simple equation A+B=C unless A and B are changed to 0, which the
it says before you go to a 0 value take C and put it in D.
IF(A1>0,C1,IF(D1>=C1,D1,0))
well this works until I copy sheets. then what is in week 3 is added t
week four. Thats problem 1. of which I can some what live with, but
would like it to work
The second part of that is (example) I am left with week four totas an
ready to start a new week on a new sheet. as soon a there is any dat
entered the total for week 4 disappears. How can I keep that data an
add to that tota