2 Replies Latest reply: Apr 4, 2017 11:50 AM by Mohammed Al Radi RSS

    How can I count the total number of distinct recipients that worked a total of 0-20 hours in 2015?

    Mohammed Al Radi

      I am trying to say 'count the total number of distinct recipients that worked a total of 0-20 hours in 2015.' The formula I have only counts the total number of rows (in the excel document) that have less than 20 hous (i.e lets say 'Matt' is recorded in 2 rows, with each row having 15 hours...the formula below counts both those lines as if they were distinct people even though they correspond to the same perosn who would have well over 20 hours).

       

      Count (distinct {$<[Total Hours]={"(>=0 <=20)"}, Year={'2015'}>}  Receipient)

       

      I am hoping i am just missing something simple! I have been scouring forums and trying different things. Thank you for your time and consideration.