Bob... Appreciate the input. Not there yet, it could be me! To expand a bit
>J10=1
>J13=1
>K13=3
>L14=5
>L15=6
>J17=1
>M17=4
>J19=1
>etc.....
>The above Result should be 6 activity days

"Bob Phillips" wrote:

> Wayne,
>
> What you do is sum the results, like
>
> =SUMIF(A10:A40,">0")
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Wayne" <Wayne@discussions.microsoft.com> wrote in message
> news:9951F45F-98D8-4D7C-AEF2-55B12885F5B2@microsoft.com...
> > Tks for the input... both give me close to what I need but I am not there
> > yet. There is a chance that there could be 1, or up to all 5 activities in
> a
> > day, but it should only register as 1 day active. If there are no entries,
> > there was no activity for that day. If there where 3 activities, that
> would
> > then show me that I had a day (1) with activity. Hope that helps!
> >
> > "Bob Phillips" wrote:
> >
> > > Bit over-engineered Stefi, =COUNTA(J10:N10) does the same but much
> simpler.
> > >
> > > Bob
> > >
> > > "Stefi" <Stefi@discussions.microsoft.com> wrote in message
> > > news:EB2C51D6-F61D-40B3-A67E-30D7C1892D7B@microsoft.com...
> > > > Assuming that a day's registered activity is marked with a not empty
> cell,
> > > > in cell O10 enter
> > > >
> > > > =SUMPRODUCT(--NOT(ISBLANK(J10:N10)))
> > > >
> > > > and fill down to O40!
> > > >
> > > > Regards,
> > > > Stefi
> > > >
> > > > "Wayne" ezt *rta:
> > > >
> > > > > J10:N40 may contain data pertaing to 5 activities on each of the
> days of
> > > the
> > > > > month. I need some help to detemine the total number of day's
> registered
> > > > > activities have taken place. Tks
> > >
> > >
> > >
>
>
>