Pasting the SUM of Negative values through SUMPRODUCT and SUMIFS

I have been using the below formula which SUM the Sheet2 values and Present Them in Sheet3.

Now i have been trying to add one more condition that is the formula should SUM the just Negative Values from the Range Sheet2!D2:D30 When Sheet2 Col"L" cell is not empty and Paste them in Sheet3.

I have attached a Sheet link which may help to solve the problem.

Here is original formula


After i have added one more condition but its not working


any help will be much appreciated.

Sheet Link


Read more here:

Content Attribution

This content was originally published by Valiant at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: