Divide by the following ... =ROWS(C3:C20)-COUNTIF(C3:C20,"")
where range(C3:C20) includes the actual data From: [email protected] [mailto:[email protected]] On Behalf Of Dennis Brown Sent: Friday, December 19, 2008 4:29 PM To: [email protected] Subject: Re: [amibroker] Off Topic: Excel Spreadsheet Question 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. > >
