3 Replies Latest reply: Feb 22, 2012 5:51 AM by uzipuzip RSS

    Several if conditions in a formula

      I want to use several if-selections in 1 formula.

       

      E.g.

       

      Country, Customer, CustomerOrders

      Netherlands, A, 5

      Netherlands, B, 7

      Netherlands, C, 8

      Belgium, N, 8

      Belgium, O, 5

      Belgium, P, 6

      Germany, A, 7

      Germany, R, 7

      Germany, S, 9

       

      The goal is to count all CustomerOrders for the Netherlands for Customers A + B, and for Belgium for Customers O + P, and for Germany for the Customers R + S

       

      I have a begin:
      Count(if(Country = Netherlands and (Customer = A or Customer = B), CustomerOrders))...but then I get stuck.

       

      Can somebody help me with this formula?