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???