If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
How do I count the # of times an entry has been made in a mont
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" 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 |
#12
|
|||
|
|||
How do I count the # of times an entry has been made in a month?
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" 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 -- surg4u1975 ------------------------------------------------------------------------ surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718 View this thread: http://www.excelforum.com/showthread...hreadid=496338 |
#13
|
|||
|
|||
How do I count the # of times an entry has been made in a mont
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" 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 |
#14
|
|||
|
|||
How do I count the # of times an entry has been made in a mont
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" 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 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I view my Calendar in the Month view without seeing times | suzyg23 | Calendar | 0 | June 9th, 2005 05:59 AM |
How do I count the number of times an entry occurs in a field? | hcampbell1966 | General Discussion | 2 | April 30th, 2005 06:47 PM |
Trying to count the number of times a "type" of value occurs | astiller | Worksheet Functions | 2 | July 9th, 2004 03:35 PM |
Time when an entry was made | Dave B | Worksheet Functions | 2 | April 5th, 2004 09:03 PM |
auto entry of month | The Scho | Worksheet Functions | 3 | March 24th, 2004 10:17 PM |