[amibroker] Re: Off Topic: Excel Spreadsheet Question

["brian_z111" <brian_z111@xxxxxxxxx>]

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 amibroker@xxxxxxxxxxxxxxx, "Jerry Gress" 
<pleasenospamplease@xxx> 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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/