software

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

?ayne??ezt ?rta:

gt; J10:N40 may contain data pertaing to 5 activities on each of the days of the
gt; month. I need some help to detemine the total number of day's registered
gt; activities have taken place. Tks

Bit over-engineered Stefi, =COUNTA(J10:N10) does the same but much simpler.

Bob

quot;Stefiquot; gt; wrote in message
...
gt; Assuming that a day's registered activity is marked with a not empty cell,
gt; in cell O10 enter
gt;
gt; =SUMPRODUCT(--NOT(ISBLANK(J10:N10)))
gt;
gt; and fill down to O40!
gt;
gt; Regards,
gt; Stefi
gt;
gt; quot;Waynequot; ezt 甏ta:
gt;
gt; gt; J10:N40 may contain data pertaing to 5 activities on each of the days of
the
gt; gt; month. I need some help to detemine the total number of day's registered
gt; gt; 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!

quot;Bob Phillipsquot; wrote:

gt; Bit over-engineered Stefi, =COUNTA(J10:N10) does the same but much simpler.
gt;
gt; Bob
gt;
gt; quot;Stefiquot; gt; wrote in message
gt; ...
gt; gt; Assuming that a day's registered activity is marked with a not empty cell,
gt; gt; in cell O10 enter
gt; gt;
gt; gt; =SUMPRODUCT(--NOT(ISBLANK(J10:N10)))
gt; gt;
gt; gt; and fill down to O40!
gt; gt;
gt; gt; Regards,
gt; gt; Stefi
gt; gt;
gt; gt; quot;Waynequot; ezt ?rta:
gt; gt;
gt; gt; gt; J10:N40 may contain data pertaing to 5 activities on each of the days of
gt; the
gt; gt; gt; month. I need some help to detemine the total number of day's registered
gt; gt; gt; activities have taken place. Tks
gt;
gt;
gt;

Wayne,

What you do is sum the results, like

=SUMIF(A10:A40,quot;gt;0quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Waynequot; gt; wrote in message
...
gt; Tks for the input... both give me close to what I need but I am not there
gt; yet. There is a chance that there could be 1, or up to all 5 activities in
a
gt; day, but it should only register as 1 day active. If there are no entries,
gt; there was no activity for that day. If there where 3 activities, that
would
gt; then show me that I had a day (1) with activity. Hope that helps!
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Bit over-engineered Stefi, =COUNTA(J10:N10) does the same but much
simpler.
gt; gt;
gt; gt; Bob
gt; gt;
gt; gt; quot;Stefiquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Assuming that a day's registered activity is marked with a not empty
cell,
gt; gt; gt; in cell O10 enter
gt; gt; gt;
gt; gt; gt; =SUMPRODUCT(--NOT(ISBLANK(J10:N10)))
gt; gt; gt;
gt; gt; gt; and fill down to O40!
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt; Stefi
gt; gt; gt;
gt; gt; gt; quot;Waynequot; ezt 甏ta:
gt; gt; gt;
gt; gt; gt; gt; J10:N40 may contain data pertaing to 5 activities on each of the
days of
gt; gt; the
gt; gt; gt; gt; month. I need some help to detemine the total number of day's
registered
gt; gt; gt; gt; activities have taken place. Tks
gt; gt;
gt; gt;
gt; gt;
Bob... Appreciate the input. Not there yet, it could be me! To expand a bit
gt;J10=1
gt;J13=1
gt;K13=3
gt;L14=5
gt;L15=6
gt;J17=1
gt;M17=4
gt;J19=1
gt;etc.....
gt;The above Result should be 6 activity days

quot;Bob Phillipsquot; wrote:

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

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,quot;gt;0quot;)--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Waynequot; gt; wrote in message
...
gt; Bob... Appreciate the input. Not there yet, it could be me! To expand a
bit
gt; gt;J10=1
gt; gt;J13=1
gt; gt;K13=3
gt; gt;L14=5
gt; gt;L15=6
gt; gt;J17=1
gt; gt;M17=4
gt; gt;J19=1
gt; gt;etc.....
gt; gt;The above Result should be 6 activity days
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Wayne,
gt; gt;
gt; gt; What you do is sum the results, like
gt; gt;
gt; gt; =SUMIF(A10:A40,quot;gt;0quot;)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Waynequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Tks for the input... both give me close to what I need but I am not
there
gt; gt; gt; yet. There is a chance that there could be 1, or up to all 5
activities in
gt; gt; a
gt; gt; gt; day, but it should only register as 1 day active. If there are no
entries,
gt; gt; gt; there was no activity for that day. If there where 3 activities, that
gt; gt; would
gt; gt; gt; then show me that I had a day (1) with activity. Hope that helps!
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Bit over-engineered Stefi, =COUNTA(J10:N10) does the same but much
gt; gt; simpler.
gt; gt; gt; gt;
gt; gt; gt; gt; Bob
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Stefiquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; Assuming that a day's registered activity is marked with a not
empty
gt; gt; cell,
gt; gt; gt; gt; gt; in cell O10 enter
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =SUMPRODUCT(--NOT(ISBLANK(J10:N10)))
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; and fill down to O40!
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Regards,
gt; gt; gt; gt; gt; Stefi
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Waynequot; ezt 甏ta:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; J10:N40 may contain data pertaing to 5 activities on each of the
gt; gt; days of
gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; month. I need some help to detemine the total number of day's
gt; gt; registered
gt; gt; gt; gt; gt; gt; activities have taken place. Tks
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
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

quot;Bob Phillipsquot; wrote:

gt; Wayne,
gt;
gt; Sorry, I gave you the wrong formula. Assuming that you have the initial
gt; counts in A10:A40, the result that you want is returned by
gt;
gt; =COUNTIF(A10:A40,quot;gt;0quot;)
gt;
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;Waynequot; gt; wrote in message
gt; ...
gt; gt; Bob... Appreciate the input. Not there yet, it could be me! To expand a
gt; bit
gt; gt; gt;J10=1
gt; gt; gt;J13=1
gt; gt; gt;K13=3
gt; gt; gt;L14=5
gt; gt; gt;L15=6
gt; gt; gt;J17=1
gt; gt; gt;M17=4
gt; gt; gt;J19=1
gt; gt; gt;etc.....
gt; gt; gt;The above Result should be 6 activity days
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; Wayne,
gt; gt; gt;
gt; gt; gt; What you do is sum the results, like
gt; gt; gt;
gt; gt; gt; =SUMIF(A10:A40,quot;gt;0quot;)
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;Waynequot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Tks for the input... both give me close to what I need but I am not
gt; there
gt; gt; gt; gt; yet. There is a chance that there could be 1, or up to all 5
gt; activities in
gt; gt; gt; a
gt; gt; gt; gt; day, but it should only register as 1 day active. If there are no
gt; entries,
gt; gt; gt; gt; there was no activity for that day. If there where 3 activities, that
gt; gt; gt; would
gt; gt; gt; gt; then show me that I had a day (1) with activity. Hope that helps!
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Bit over-engineered Stefi, =COUNTA(J10:N10) does the same but much
gt; gt; gt; simpler.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Bob
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Stefiquot; gt; wrote in message
gt; gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; gt; Assuming that a day's registered activity is marked with a not
gt; empty
gt; gt; gt; cell,
gt; gt; gt; gt; gt; gt; in cell O10 enter
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; =SUMPRODUCT(--NOT(ISBLANK(J10:N10)))
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; and fill down to O40!
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Regards,
gt; gt; gt; gt; gt; gt; Stefi
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot;Waynequot; ezt ?rta:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; J10:N40 may contain data pertaing to 5 activities on each of the
gt; gt; gt; days of
gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; gt; month. I need some help to detemine the total number of day's
gt; gt; gt; registered
gt; gt; gt; gt; gt; gt; gt; activities have taken place. Tks
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;


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,quot;gt;0quot;).

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: www.excelforum.com/member.php...oamp;userid=28718
View this thread: www.excelforum.com/showthread...hreadid=496338Wayne

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

George GeeWayne wrote:
gt; Bob... I am not getting my thoughts across to you. I have five
gt; classes that I cover each day, and there is a chance that on some
gt; days I do not have one of or any of those five classes. I want to
gt; see/total the number of days that I had classes in that month, not
gt; the number of classes. I already have the total of the individual
gt; classes for each month. The five classes are in cells J10:N10 for the
gt; month, therefore J10:N40.
gt; I could have 3 out of the 5 classes on a particular day. I want to be
gt; able to count that as 1 day with classes, in the month.
gt; In my previous post, the total number of days with classes would have
gt; been six (6)!
gt; Again... Tks
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt;gt; Wayne,
gt;gt;
gt;gt; Sorry, I gave you the wrong formula. Assuming that you have the
gt;gt; initial counts in A10:A40, the result that you want is returned by
gt;gt;
gt;gt; =COUNTIF(A10:A40,quot;gt;0quot;)
gt;gt;
gt;gt;
gt;gt; --
gt;gt;
gt;gt; HTH
gt;gt;
gt;gt; RP
gt;gt; (remove nothere from the email address if mailing direct)
gt;gt;
gt;gt;
gt;gt; quot;Waynequot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Bob... Appreciate the input. Not there yet, it could be me! To
gt;gt;gt; expand a
gt;gt; bit
gt;gt;gt;gt; J10=1
gt;gt;gt;gt; J13=1
gt;gt;gt;gt; K13=3
gt;gt;gt;gt; L14=5
gt;gt;gt;gt; L15=6
gt;gt;gt;gt; J17=1
gt;gt;gt;gt; M17=4
gt;gt;gt;gt; J19=1
gt;gt;gt;gt; etc.....
gt;gt;gt;gt; The above Result should be 6 activity days
gt;gt;gt;
gt;gt;gt; quot;Bob Phillipsquot; wrote:
gt;gt;gt;
gt;gt;gt;gt; Wayne,
gt;gt;gt;gt;
gt;gt;gt;gt; What you do is sum the results, like
gt;gt;gt;gt;
gt;gt;gt;gt; =SUMIF(A10:A40,quot;gt;0quot;)
gt;gt;gt;gt;
gt;gt;gt;gt; --
gt;gt;gt;gt; HTH
gt;gt;gt;gt;
gt;gt;gt;gt; Bob Phillips
gt;gt;gt;gt;
gt;gt;gt;gt; (remove nothere from email address if mailing direct)
gt;gt;gt;gt;
gt;gt;gt;gt; quot;Waynequot; gt; wrote in message
gt;gt;gt;gt; ...
gt;gt;gt;gt;gt; Tks for the input... both give me close to what I need but I am
gt;gt;gt;gt;gt; not there yet. There is a chance that there could be 1, or up to
gt;gt;gt;gt;gt; all 5 activities in a day, but it should only register as 1 day
gt;gt;gt;gt;gt; active. If there are no entries, there was no activity for that
gt;gt;gt;gt;gt; day. If there where 3 activities, that would then show me that I
gt;gt;gt;gt;gt; had a day (1) with activity. Hope that helps!
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt; quot;Bob Phillipsquot; wrote:
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Bit over-engineered Stefi, =COUNTA(J10:N10) does the same but
gt;gt;gt;gt;gt;gt; much simpler.
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; Bob
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt; quot;Stefiquot; gt; wrote in message
gt;gt;gt;gt;gt;gt; ...
gt;gt;gt;gt;gt;gt;gt; Assuming that a day's registered activity is marked with a not
gt;gt;gt;gt;gt;gt;gt; empty cell, in cell O10 enter
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; =SUMPRODUCT(--NOT(ISBLANK(J10:N10)))
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; and fill down to O40!
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; Regards,
gt;gt;gt;gt;gt;gt;gt; Stefi
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt; quot;Waynequot; ezt 甏ta:
gt;gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;gt; J10:N40 may contain data pertaing to 5 activities on each of
gt;gt;gt;gt;gt;gt;gt;gt; the days of the month. I need some help to detemine the total
gt;gt;gt;gt;gt;gt;gt;gt; number of day's registered activities have taken place. Tks