+ Reply to Thread
Results 1 to 13 of 13

problem in countif function

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    problem in countif function

    hi all,
    i am using office 2007 and i want to calculate the no. of days for which there is a remark ( for example tea , coffee.....). pls help me to create a formula for January which will give me the result as '6'.....as there is 6 days in January for which any remark is there....i will implement the same formula for other months, i can't sort these two columns because of data in other columns. if another formula can be used pls tell me. i had used =COUNTIF(b5:b19,">=2012.01.01","<=2012.01.31")
    here i am adding a snap for better understanding.....


    excel.jpg
    Last edited by hello911helpme; 11-21-2012 at 06:08 AM.

  2. #2
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: pls help me solve my problem....

    pls attach the sample file.

    thanks

  3. #3
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: pls help me solve my problem....

    Hi - Your post does not comply with Rule #1 of the Forum:

    1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

    Please take a moment to read the rules at http://www.excelforum.com/forum-rule...rum-rules.html
    If solved kindly remember to mark Thread as solved.
    Click the small star icon at the bottom left of my post if this was useful.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: pls help me solve my problem....

    Your Title is not complying with Forum Rule No.1.

    As a suggestion you can use the title as "Using Countif with Date's"

    To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  5. #5
    Registered User
    Join Date
    11-21-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: problem in countif function

    i tried to edit my thread as suggested by some senior members....pls feel free if something is still wrong with the thread.....

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: problem in countif function

    It seems to be the Date's are Text Data so find below the formula to get the result from Text Date's.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: problem in countif function

    @ Sixthsense

    Sometimes you can not assume

    Todays date 21/11/2012 Formatted, custom, yyyy"."mm"."dd and left aligned = 2012.11.21

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: problem in countif function

    Quote Originally Posted by Kevin UK View Post
    @ Sixthsense
    Yes, you are right but people in India won't prefer to use dots as a separator in Date's.

  9. #9
    Registered User
    Join Date
    11-21-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: problem in countif function

    Quote Originally Posted by :) Sixthsense :) View Post
    It seems to be the Date's are Text Data so find below the formula to get the result from Text Date's.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    when i used the above formula, its result was 9, while i just want to calculate the numbers for january month, which will be 6.

  10. #10
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: problem in countif function

    Use this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Will give you 6 for January and 2 for February when you change 1 to 2.

    Hope this helps...

  11. #11
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: problem in countif function

    I believe that the some of the cells in column c which seems to be blank will have spaces in it.

  12. #12
    Registered User
    Join Date
    11-21-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: problem in countif function

    Quote Originally Posted by kbkumar View Post
    Use this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Will give you 6 for January and 2 for February when you change 1 to 2.

    Hope this helps...
    Thanks 'kbkumar'......it worked....

  13. #13
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: problem in countif function

    You are welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1