I want to sum values in a column based on values on the same row in another column.
The condition is that the value is counted if either
- other cell on the same row has nothing or
- other cell on the same row has value less than 2000
In the screenshot I want values in column A summed on row 1, 2 and 3. Row 4 is not counted, because on C4 there is 2000. The result would be 100 + 200 + 50 = 350.