5 Replies Latest reply: Oct 26, 2017 6:43 AM by Munetsi Danga RSS

    Sum a range of Accounts

    Munetsi Danga

        Hi Community,

       

      Please help with a simple formula to Sum a range of Account numbers as follows:

       

      1. Sum Amount for the Accounts 5722  to 5728  ( I want to state a range NOT to list them all)

      2. Sum Amount for the range of Accounts 2300 to 2480

      3. Then Subtract (2.) from (1.)

       

      Below is just a sample , the Accounts are way too many than this hence the reason why i cant use a formula such as

       

      WHERE Acc IN (5722, 5722.........)

       

      AccAmount
      57226000
      5723850
      57246850
      57257700
      572614550
      572722250
      572836800
      34699625
      230014300
      23306400
      23607900
      23904500
      24203400
      24501100
      24802300