Question: how to calculate positive and negative numbers in excel?
Answer: Enter data as in the example given below. Select cell E13 and type =SUMIF(E4:E12,”>0”) Select cell E14 and type =SUMIF(E4:E12,”<0”) The result will be as below.