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

Wayne,

Sorry, I gave you the wrong formula. Assuming that you have the initial
counts in A10:A40, the result that you want is returned by

=COUNTIF(A10:A40,">0")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Wayne" <Wayne@discussions.microsoft.com> wrote in message
news:709A330B-DC30-4939-BCF4-0E8DFA3C24A4@microsoft.com...
> 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
> > > >
> > > >
> > > >
> >
> >
> >

Bob... I am not getting my thoughts across to you. I have five classes that I
cover each day, and there is a chance that on some days I do not have one of
or any of those five classes. I want to see/total the number of days that I
had classes in that month, not the number of classes. I already have the
total of the individual classes for each month. The five classes are in cells
J10:N10 for the month, therefore J10:N40.
I could have 3 out of the 5 classes on a particular day. I want to be able
to count that as 1 day with classes, in the month.
In my previous post, the total number of days with classes would have been
six (6)!
Again... Tks

"Bob Phillips" wrote:

> Wayne,
>
> Sorry, I gave you the wrong formula. Assuming that you have the initial
> counts in A10:A40, the result that you want is returned by
>
> =COUNTIF(A10:A40,">0")
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Wayne" <Wayne@discussions.microsoft.com> wrote in message
> news:709A330B-DC30-4939-BCF4-0E8DFA3C24A4@microsoft.com...
> > 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.

Wayne

In O10 =IF(SUM(J10:N10)>0,1,0) Copy down to O40
In O41 =SUM(O10:O40)

George Gee


Wayne wrote:
> Bob... I am not getting my thoughts across to you. I have five
> classes that I cover each day, and there is a chance that on some
> days I do not have one of or any of those five classes. I want to
> see/total the number of days that I had classes in that month, not
> the number of classes. I already have the total of the individual
> classes for each month. The five classes are in cells J10:N10 for the
> month, therefore J10:N40.
> I could have 3 out of the 5 classes on a particular day. I want to be
> able to count that as 1 day with classes, in the month.
> In my previous post, the total number of days with classes would have
> been six (6)!
> Again... Tks
>
> "Bob Phillips" wrote:
>
>> Wayne,
>>
>> Sorry, I gave you the wrong formula. Assuming that you have the
>> initial counts in A10:A40, the result that you want is returned by
>>
>> =COUNTIF(A10:A40,">0")
>>
>>
>> --
>>
>> HTH
>>
>> RP
>> (remove nothere from the email address if mailing direct)
>>
>>
>> "Wayne" <Wayne@discussions.microsoft.com> wrote in message
>> news:709A330B-DC30-4939-BCF4-0E8DFA3C24A4@microsoft.com...
>>> 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

Perhaps this is a better way to explain... one week
>J10:N10 blank
>J11 blank
>K11 1.4 (hrs)
>L11:N11 blank
>J12 blank
>K12 (1.3) hrs
>L12 blank
>M12:N12 (1.3 & 1.5) hrs respt
>J13 (1.3) hrs
>K13:N13 blank
>J14:K14 (1.3 & 1.3) hrs respt
>L14:N14 blank
>J15:N15 blank
>J16:N16 blank
The above should show 4 days worked! How do I do this? All of the input up
to now has given me a total cell count, when that is not what I require. I
need a Row (Non blank) count, showing in this case 4 days worked. Tks

"Bob Phillips" wrote:

> Wayne,
>
> Sorry, I gave you the wrong formula. Assuming that you have the initial
> counts in A10:A40, the result that you want is returned by
>
> =COUNTIF(A10:A40,">0")
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Wayne" <Wayne@discussions.microsoft.com> wrote in message
> news:709A330B-DC30-4939-BCF4-0E8DFA3C24A4@microsoft.com...
> > 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>

I used George's formulas and mine, both gave a result of 4. His in O41, mine in P10.

George's:
O10 =IF(SUM(J10:N10)>0,1,0) filled down to O40
O41 =SUM(Q10:Q40)

Mine:
O10 =COUNTA(J10:N10) filled down to O40
P10 =COUNTIF(O10:O40,">0")


Wayne wrote: Perhaps this is a better way to explain... one week
>J10:N10 blank
>J11 blank
>K11 1.4 (hrs)
>L11:N11 blank
>J12 blank
>K12 (1.3) hrs
>L12 blank
>M12:N12 (1.3 & 1.5) hrs respt
>J13 (1.3) hrs
>K13:N13 blank
>J14:K14 (1.3 & 1.3) hrs respt
>L14:N14 blank
>J15:N15 blank
>J16:N16 blank
The above should show 4 days worked! How do I do this? All of the input up
to now has given me a total cell count, when that is not what I require. I
need a Row (Non blank) count, showing in this case 4 days worked. Tks

"Bob Phillips" wrote:

> Wayne,
>
> Sorry, I gave you the wrong formula. Assuming that you have the initial
> counts in A10:A40, the result that you want is returned by
>
> =COUNTIF(A10:A40,">0")
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Wayne" <Wayne@discussions.microsoft.com> wrote in message
> news:709A330B-DC30-4939-BCF4-0E8DFA3C24A4@microsoft.com...
> > 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>[/QUOTE]

Thanks GG... et all! I am a happy camper now! Best of the season to you all.
.... Wayne

"George Gee" wrote:

> Wayne
>
> In O10 =IF(SUM(J10:N10)>0,1,0) Copy down to O40
> In O41 =SUM(O10:O40)
>
> George Gee
>
>
> Wayne wrote:
> > Bob... I am not getting my thoughts across to you. I have five
> > classes that I cover each day, and there is a chance that on some
> > days I do not have one of or any of those five classes. I want to
> > see/total the number of days that I had classes in that month, not
> > the number of classes. I already have the total of the individual
> > classes for each month. The five classes are in cells J10:N10 for the
> > month, therefore J10:N40.
> > I could have 3 out of the 5 classes on a particular day. I want to be
> > able to count that as 1 day with classes, in the month.
> > In my previous post, the total number of days with classes would have
> > been six (6)!
> > Again... Tks
> >
> > "Bob Phillips" wrote:
> >
> >> Wayne,
> >>
> >> Sorry, I gave you the wrong formula. Assuming that you have the
> >> initial counts in A10:A40, the result that you want is returned by
> >>
> >> =COUNTIF(A10:A40,">0")
> >>
> >>
> >> --
> >>
> >> HTH
> >>
> >> RP
> >> (remove nothere from the email address if mailing direct)
> >>
> >>
> >> "Wayne" <Wayne@discussions.microsoft.com> wrote in message
> >> news:709A330B-DC30-4939-BCF4-0E8DFA3C24A4@microsoft.com...
> >>> 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
>
>
>

Wayne

Are the cells that you say are 'Blank', truly blank?
Or have they some other data in them?

The formulas that you have been given, require that if you have not
worked, that the cells are indeed blank!

Or do you enter some data into the 'unworked' cells?
If so, what?

George Gee



Wayne wrote:
> Perhaps this is a better way to explain... one week
>> J10:N10 blank
>> J11 blank
>> K11 1.4 (hrs)
>> L11:N11 blank
>> J12 blank
>> K12 (1.3) hrs
>> L12 blank
>> M12:N12 (1.3 & 1.5) hrs respt
>> J13 (1.3) hrs
>> K13:N13 blank
>> J14:K14 (1.3 & 1.3) hrs respt
>> L14:N14 blank
>> J15:N15 blank
>> J16:N16 blank
> The above should show 4 days worked! How do I do this? All of the
> input up to now has given me a total cell count, when that is not
> what I require. I need a Row (Non blank) count, showing in this case
> 4 days worked. Tks
>
> "Bob Phillips" wrote:
>
>> Wayne,
>>
>> Sorry, I gave you the wrong formula. Assuming that you have the
>> initial counts in A10:A40, the result that you want is returned by
>>
>> =COUNTIF(A10:A40,">0")
>>
>>
>> --
>>
>> HTH
>>
>> RP
>> (remove nothere from the email address if mailing direct)
>>
>>
>> "Wayne" <Wayne@discussions.microsoft.com> wrote in message
>> news:709A330B-DC30-4939-BCF4-0E8DFA3C24A4@microsoft.com...
>>> 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