In this video, I explained how to calculate negative or positive values in a range, we can apply "=sumif" function for that but in that formula we can have one condition only. You can download practice file by click on that link "https://docs.google.com/spreadsheets/..."
In next video I'll explain "=sumifs" function, basically in that function we can have multiple conditions.