Results 1 to 13 of 13

problem in countif function

Threaded View

  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.

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