4 Replies Latest reply on Nov 1, 2014 1:29 PM by gkaiseril

    sum a group of numbers

    James A Hiltz CET Level 1

      I have a group of 90 cells within a form labeled "B1" to "B90". I need to sum the highest cell number with a value in it and the previous 3.

      for example: B20+B21+B22+B23

      some of the preceding cells may be blank or equal to "0"

      What is the best way to salve this?