I understand now what you're doing. No problem.
I won't have the revised ss done until tomorrow. But, to make your charts for tonight.
Go to MO and on 3/1/01 on the NET VOLUME UP paste: =IF(HG341>=0,HH340+HG341)+IF(HG341<0,"0")
On the NET VOLUME DOWN paste: =IF(HG341<=0,HI340+HG341)+IF(HG341>0,"0")
On the UP column paste: =IF(HH341=0,"0")+IF(HH341<ABS(HK341),"0")+IF(HH341>ABS(HK341),"1")
And on the DOWN column paste: =IF(HI341=0,"0")+IF(ABS(HI341)<HJ341,"0")+IF(ABS(HI341)>HJ341,1)
Drag them down and you'll be on the money with MO.
Take care,
Eric |