Excel Help

[slaughteredlamb]

I have a spreadsheet with the following columns:

D= Total I Paid For Item
I= Total I Item Sold For
J = Fee 1
K = Fee 2
L = Fee 3
M = Fee 4

Currently I have a formula which works out my total profit by subtracting I-M from D =SUM(I6-D6-J6-K6-L6-M6)

However I now want to add another cell which only displays the result of the sum IF column D has a value higher than 0 so kinda something like =IF D>0 Sum(I6-D6-J6-K6-L6-M6) but how do you write that in a way that Excel understands?

[JasonD]

=IF(D6>0,I6-D6-J6-K6-L6-M6,"")

There is no need for SUM here.

[slaughteredlamb]

Ahh cheers Jason, that's where I was going wrong. Really must learn more about Excel formulas!