Thanks for the replies, following gives me a number to divide by assuming profit or loss:)
=COUNTIF(I3:I29,"<>0") Jerry Gress Stockton, Ca. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of brian_z111 Sent: Friday, December 19, 2008 2:23 PM To: [email protected] Subject: [amibroker] Re: Off Topic: Excel Spreadsheet Question You mean in Excel? Column A formatted as numbers then enter Column B A1 = isnumber(A1) A2 = isnumber(A2) -------------------- = countif(B1:B2,"TRUE") You can also use sum if you want the total. --- In [email protected], "Jerry Gress" <pleasenospample...@...> 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. > ------------------------------------ **** IMPORTANT **** This group is for the discussion between users only. This is *NOT* technical support channel. ********************* TO GET TECHNICAL SUPPORT from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com ********************* For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: http://www.amibroker.com/devlog/ For other support material please check also: http://www.amibroker.com/support.html ********************************* Yahoo! Groups Links
