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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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.


--
surg4u1975
------------------------------------------------------------------------
surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718
View this thread: http://www.excelforum.com/showthread...hreadid=496338

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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