If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...
Sum only negative values in a given range using SUMIF() Your email has been sent Summing only the positive or negative values in the same range of values only sounds difficult. Fortunately, the SUMIF( ...