Hi Jerry, I ran into a similar problem. I added an extra column that had a 0 or 1 if the date should be counted. I can't remember now, but I think I automatically generated that column based on some other data, but it could be filled in by hand also.
BR, Dennis On Dec 19, 2008, at 3:58 PM, Jerry Gress wrote: > Hello All, > > I keep a monthly spread sheet of actual trades (notes, etc.) and > like to > automatically do an average of the day's results. For now I divide > by the > number of inputed days by counting number of days, but can not find > how to > divide by the number of days that have actual data. > > Appreciate any help. > > Happy Holidays > > Jerry Gress > Stockton, Ca. > >
