Excel 2007 : If >=0 and sumif or sumproduct

[Jerseynjphillypa]

I am trying to sum Amount Ordered and Extra together and sum stock and gone together. But if any of the columns have no value, I don't want it to do the calculation. I keep getting an error and I don't know how to fix it.

But eventually I am trying to write a function in one line in sheet 2 under Traffic so I can assign a conditional formatting.

So if Sum of Stock and Gone is greater or equal to Sum of Amount Order and Extra it should be 2 or yellow



=If(Inventory!$E$2:$E$7,Inventory!$A$2:$A$7,Sheet2!$A7,Inventory!$B$2:$B$7,Sheet2!$B7),(Inventory!$F$2:$F$7,Inventory!$A$2:$A$7,Sheet2!$A7,Inventory!$B$2:$B$7,Sheet2!$B7),">=0"),SUM(SUMIFS(Inventory!$E$2:$E$7,Inventory!$A$2:$A$7,Sheet2!$A7,Inventory!$B$2:$B$7,Sheet2!$B7),SUMIFS(Inventory!$F$2:$F$7,Inventory!$A$2:$A$7,Sheet2!$A7,Inventory!$B$2:$B$7,Sheet2!$B7),3,2)