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.