Hi, I try use SUMIF formula to calculation our company total salary , example as below,
Untitled.png

In Comm side, I using IF(MAX(MIN)) formula to calculate all comm, if agent not reach the target , the column will show me negative number because of i set all formula already.

For negative number , i have use custom format to reset the display, format is #,##0;"0" , but it is only change the display , no change the cell value. In the end , when i sum all comm, will get the negative number too. I try use SUMIF to sum all positive number but SUMIF only can sum in a range .

So the question is how i can SUM all positive number in different column?