Question: how to calculate only negative numbers in excel?
Answer: To sum all negative numbers only in a range, please use this formula =SUMIF($A$1:$D$7,"<0"). 2. In the above formula, A1:D7 is the data range that you want to use.