Circular reference Excel 2013

[zeerava]

I have started to use Excel 2013 and got issue with circular reference which I never have had before.

So there is 3 columns:
1. TOTAL SUMIF DATE: which counts totals for invoice if there is no invoice number but there is invoice date.
formula: =IF(AND(C10>0,D10=0),SUMIF(A10:$I$54,C10,I10:$I$54),0)
Cell J14

2. TOTAL SUMIF INVOICE NO: which counts total for invoice if it has invoice number and date
formula: =IF(AND(C10>0,D10>0),SUMIF($A$10:$I$54,D10,$I$10:$I$54),0)
Cell K14

3. TOTAL: which displays one of results
formula: =IF(K14>0,K14,J14)
Cell: L14

After I type the TOTAL formula Excel informs me about Circular reference in cells K14 and L14. I have typed other formulas like when one cell counts TOTAL, one to right counts VAT based on total and one more to right counts TOTAL + VAT using sum. Excel still shows me message about circular reference.
I looked it up in net and couldn't find anything related to this. at the moment i have enabled interactive calculations, but you do that if result of formula depends on it's own value. at least I have never enabled interactive calculations because using older versions of excel and using same principles of making tables nothing like this have happened.

Could you please explain me why this is happening and what I'm doing wrong?

 

[Rambo4711]

Your lookup range A10:I54 includes your sum range I10:I54

J14: =IF(AND(C10>0,D10=0),SUMIF(A10:$I$54,C10,I10:$I$54),0)
K14: =IF(AND(C10>0,D10>0),SUMIF($A$10:$I$54,D10,$I$10:$I$54),0)

I guess that your lookup range should be $A$10:$A$54