2 Replies Latest reply: Jun 29, 2017 9:18 AM by Felix Moran RSS

    Count items that fulfill criteria of 2 different fields.

    Felix Moran


      so far I was counting items fulfilling criterias on 1 field.

      But now I need to count items fulfilling criterias on 2 fields.

      Can any body helps please?


      This was counting items of LH, that fulfills the criterias on field Rev.



      Now I need something that makes the same but fulfilling in addition on the field Status the different Statuses {'in review','certified'}

      With this I want to exclude all items which have the Rev numbers defined but are with a wrong status "obsolete".


      Please I need the formula the soonest possible,


      Thanks for the help,