How do I count the # of times an entry has been made in a month?

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

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

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

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

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

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

Sorry to interject, but I generally read these threads for my own education.

Could you add a formula to column O, where O10 would =COUNTA(J10:N10), then fill down to O40. Then in P10 enter =COUNTIF(O2:O32,">0").

I think this accomplishes what you want, but not in one formula therefore I may be over simplifying and should have stayed out of this conversation.