I have a formula in my Excel sheet that looks like this:

```
1000 - SUMIF($B:$B;"A1400";$A:$A) - SUMIF($B:$B;"B1400";$A:$A) - SUMIF($B:$B;"C1400";$A:$A) - ...
```

And there are a lot more SUMIF that follow. Is there a way to avoid writing it like this, to condense the ~15 SUMIF statements? For example, can I tell Excel to draw the criteria (A1400, B1400, C1400) from a cell range or an array?

`=COUNTIF(X:X;B2)`

, and your complex formula will be`=1000-SUMIF(C:C;">0";A:A)`

)