1 Reply Latest reply on Feb 14, 2020 4:01 AM by Philip Fernandez

    getting items that appear in any set

    Philip Fernandez

      I have four different sets and want to add up all the sales for the companies which appear in any set.

       

      When I use this formula :-

       

       

      The total sales comes to 28,020,915 which is the total sales when they appear in the specific sets.

       

      If I use :-

       

      I get 33,274,647 which is the total sales of the companies if they appear in any set.

       

      The sets are defined as :-

       

       

      Why should the two formulas above give different results???

       

      Thanks

      Phil