10 Replies Latest reply: Feb 12, 2016 4:07 AM by V SUDHAKAR RSS

    Counting based on 3 cases

    Dermot mcgoldrick

      I have 3 separate lists of data and I want to check how many items exist on all three lists.

       

      I thought this might work :

       

      =aggr(count(Distinct Item) LIST)

       

      But not getting anywhere with it?  If I then wanted to count the number on specific lists, lets say only those items that appear on list 1 and 2, where the price is different and then another count where the price is the same how would you achieve it.