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.
>
