5 Replies Latest reply: Jan 5, 2018 9:57 AM by Sunny Talwar RSS

    Count if with Week numbers and Year

    Erwin Vullers

      Hi there I'm having trouble getting the formula I need.

       

      in an Excel sheet with data, I have a column that is calls 'week number',  one is called 'Year' and I have a column called 'Incident Number'

       

      I want to count all the Incident numbers in the current week and the current year.

       

      First I used this formula Count(IF([Week number]= Week(Today()),[Incident Number])) which works but now I need to add the Year as well.

       

      any one who call help me?