11 Replies Latest reply on Jun 28, 2016 11:50 AM by Diogo Braga

    Conditional format sum positive numbers (ignore negative).

    Diogo Braga

      I have the following enrollment data organized by grade-level (columns). I need to calculate school-wide open seats, but can't do a regular roll up since there are negative and positive numbers. In this situation, when open seats are negative, it means the grade is over enrolled and it shouldn't be factored in the school-wide open seats calculation. In this example, we need to sum only the positive numbers (show in red). 45 + 1 + 8 + 13 + 8 + 11 + 9 = 95

       

      After that I also need to add the pipeline numbers below (all positive), but only add the numbers from the squares where the open seats are red.

       

      How do I do that?

       

      2016-06-27_1652.png