SUMIF positive number only

[mic1412]

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?

[etaf]

rather than image

sumifs()
range , criteria >0

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[mic1412]

In the attach file will find the negative number in Sale tier and Comm 7/3 8/2 because of I set all formula already
I using custom format #,##0;"0" to change negative number to 0 ,
But it is only change the display and the value still is negative number.
I has try using SUMIF formula to sum all comm , but it only work in a range.


What can i do if i only want SUM 5/5,6/4,7/3,8/2,9/1 in D22 , E22 and F22 ?

[etaf]

in cell E22
=E11+E13+E15+E17+E19

can you say cells that do not have "sale tier" in
and greater than zero
=SUMIFS(E10:E19,C10:C19,"<>"&"sale tier",E10:E19,">0")
but i get 3900
which looks right
if you ignore the negative values

see column H

[mic1412]

Thanks bro, it is helpful !!!