 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2005Count Function
I am using the count function for attendance tracking of Vacation, Personal Time, & Sick Time. (Example: =COUNTIF($F6:$CQ6, "V") Problem is that, now I need to be able to do half days. I have tried many different formulas/ways to incorporate the half day scenario even without using the count function with no success. Do anybody have any ideas? I think you're telling us you can't figure out a code for half days? I mean... if it's a half day vacation, why not HV? Then: =countif($F6:$CQ6, "V")+(countif($F6:$CQ6, "HV")*.5) ? ************ Anne Troy VBA Project Manager www.OfficeArticles.com >I am using the count function for attendance tracking of Vacation, Personal > Time, & Sick Time. (Example: =COUNTIF($F6:$CQ6, "V") [quoted text clipped - 4 lines] > > Do anybody have any ideas? That worked Thx so much you have no idea how long I have spent on this. > I think you're telling us you can't figure out a code for half days? I > mean... if it's a half day vacation, why not HV? Then: =countif($F6:$CQ6, [quoted text clipped - 13 lines] > > > > Do anybody have any ideas? VERY cool. :) ************ Anne Troy VBA Project Manager www.OfficeArticles.com > That worked Thx so much you have no idea how long I have spent on this. > [quoted text clipped - 18 lines] >> > >> > Do anybody have any ideas? Anne: One more question for you. I also have a conditional format saying that if formula is =G6="v" then the cell would turn color. How would I incorporate that into the HV scenario? > I think you're telling us you can't figure out a code for half days? I > mean... if it's a half day vacation, why not HV? Then: =countif($F6:$CQ6, [quoted text clipped - 13 lines] > > > > Do anybody have any ideas? So you want it to turn to the same color if it's V or HV? I think you just need to set a 2nd condition same as the first, but HV instead of V. Got me? ************ Anne Troy VBA Project Manager www.OfficeArticles.com > Anne: > [quoted text clipped - 22 lines] >> > >> > Do anybody have any ideas? Hi Steve =OR(G6="v",G6="hv") Regards Roger Govier > Anne: > [quoted text clipped - 19 lines] >>> >>>Do anybody have any ideas? I knew it! (That's why my reply said "I think".) Thanks, Roger. ************ Anne Troy VBA Project Manager www.OfficeArticles.com > Hi Steve > [quoted text clipped - 30 lines] >>>> >>>>Do anybody have any ideas? Hi Anne I hadn't seen your response when posting, but looking at it now, you did say the same thing. I guess I just gave the formula rather than the reason. You "thunk" correctly<vbg>. Regards Roger Govier > I knew it! (That's why my reply said "I think".) Thanks, Roger. > ************ [quoted text clipped - 36 lines] >>>>> >>>>>Do anybody have any ideas? Oh, no. I meant I knew there had to be a formula that would do it in one format, rather than using two... :) You supplied it. ************ Anne Troy VBA Project Manager www.OfficeArticles.com > Hi Anne > I hadn't seen your response when posting, but looking at it now, you did [quoted text clipped - 46 lines] >>>>>> >>>>>>Do anybody have any ideas? need more info. how do you represent half day in your sheet. Solved the problem thx for your help. > need more info. how do you represent half day in your sheet. Steve, The way I do this is to use an upper-case letter for a full day, lower-case for a half-day. SO, assuming my absence code is in A1 (upper or lower), I use =SUMPRODUCT(--(ISNUMBER(FIND(LOWER(A2),A1:M1)))/2+ISNUMBER(FIND(UPPER(A2),A1 :M1))) to calculate the total.  SignatureHTH RP (remove nothere from the email address if mailing direct) > I am using the count function for attendance tracking of Vacation, Personal > Time, & Sick Time. (Example: =COUNTIF($F6:$CQ6, "V") [quoted text clipped - 4 lines] > > Do anybody have any ideas? Hi Steve, We use a quite simple spreadsheet in 2 companies with ca. 25 employees each: http://www.sulprobil.com/html/vacation_plan.html HTH, Bernd |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.