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