Help with subtraction while ignoring a negative value in a cell.

[ravi008]

Hello all, first time i am posting something so please ignore any mistakes. Anyway i am stuck what i would like to get done is:

In column E i would like the result from the columns A, B, C and D respectively.
Column B has an amount which is derived from adding sums of previous E and next A.
The amount in Column C and D could be negative or positive or blank.
Now basically to get the result in E i would like to subtract C and D from B, but the condition is if either C or D are negative or blank then they should be ignored.
This is how my spreadsheet looks right now.

EXCEL SNAP1.jpg


Don't know if it can be done but any help would be greatly appreciated. Thanks

[benishiryo]

hi ravi008, welcome to the forum. assuming your data in A2:D6, try this in E2:
=B2-SUMIF(C2:D2,">0")

to get better help next time, attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[ravi008]

Hi Benishiryo thank you very much for your reply it solved my problem.

[Pepe Le Mokko]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic