2 Replies Latest reply: Feb 23, 2018 9:45 AM by Elizabeth Viso RSS

    Count a set of numbers with and exclusion

    Elizabeth Viso

      Hello,

       

      I am counting how many cells contain > 80% but also want to exclude any that contain 100%. This is what I have which works but I have to add the fact of not counting the 100% in that set of data.

       

      Count({<[UMHC SYSTEM]={'>0.8'},[EC-LS-EM]= {'EC'}>} [UMHC SYSTEM])/16

       

       

      Thanks for your help in advance!