how to calculate only negative values in excel?
1. If you want to count the number of negative values only, please apply this formula =COUNTIF($A$1:$D$7,"<0"). 2. And in the above formula, A1:D7 is the data range that you want to use.