Fortunately, the SUMIF() function can handle both. Summing only the negative values in a range of values sounds like a difficult task, but there’s a simple solution-use SUMIF(). In fact ...