10 Replies Latest reply: Mar 27, 2018 8:03 AM by Elizabeth Viso RSS

    Issue Counting Data

    Elizabeth Viso

      Hello,

       

      I have an excel sheet that I'm trying to count the individual Rooms which are 44. But instead, regardless of what I do, it is counting the individual count of the days where you see 13, 14, 15 which is a total 484 (which is 44 rooms x the 11 days that are marked). I'm not sure why this is happening, all I want is a count of the rooms which is 44.

       

      Capture1.PNG

       

      Thank you!