7 Replies Latest reply: Feb 16, 2013 1:10 PM by khadar basha RSS

    Count if...

      Hi guys im in need of some help here.

       

      I am building a bar chart and want to display two things, tasks that are ontime and tasks that are overdue.

       

      I am using this for ontime and it seems to work ok and give me the right number.

           =COUNT(IF(CLOSED_DATE <= DEADLINE_DATE AND CLOSED_TIME <= DEADLINE_TIME,1))

       

      However when i want to calculate the overdue tasks and use this

           =COUNT(IF(CLOSED_DATE >> DEADLINE_DATE AND CLOSED_TIME >> DEADLINE_TIME,1))

      ...it doesnt seem to work correctly.

       

      If anyone can tell me where i am going wrong i would be very greatful.

       

      Thanks in advance.