Where is my circular reference?

[DashboardNovice]

I am being notified that I have circular reference, but I can't see where in my formula the circular reference is. Can anybody catch it?

=IF(D$13="Intuit",SUMIFS('Intuit Deductions'!$F:$F,'Intuit Deductions'!$E:$E,$B83,'Intuit Deductions'!$C:$C,EOMONTH(D$14,0),'Intuit Deductions'!$A:$A,"Dental"),IF(D$13="Invoice",SUMIFS(INDIRECT("'"&$D$11&"'!"&$E:$E),INDIRECT("'"&$D$11&"'!"&$A:$A),$B83,INDIRECT("'"&$D$11&"'!"&$B:$B),EOMONTH(D$14,0)),B83-C83))

 

[Luke M]

Very hard to tell w/o seeing the file itself. What cell is the formula itself in? What is in these cells:

1. D13
2. D11
3. D14
4. B83
5. C83

 

[NARAYANK991]

Hi ,

Apart from the circular reference , the second part of your posted formula is not correct.

SUMIFS(INDIRECT("'"&$D$11&"'!"&$E:$E),INDIRECT("'"&$D$11&"'!"&$A:$A),$B83,INDIRECT("'"&$D$11&"'!"&$B:$B),EOMONTH(D$14,0))

needs to have double quotes around the column references , as in :

SUMIFS(INDIRECT("'" & $D$11 & "'!" & "$E:$E"),INDIRECT("'" & $D$11 & "'!" & "$A:$A"),$B83,INDIRECT("'" & $D$11 & "'!" & "$B:$B"),EOMONTH(D$14,0))

Narayan

 

[DashboardNovice]

Hi ,

Apart from the circular reference , the second part of your posted formula is not correct.

SUMIFS(INDIRECT("'"&$D$11&"'!"&$E:$E),INDIRECT("'"&$D$11&"'!"&$A:$A),$B83,INDIRECT("'"&$D$11&"'!"&$B:$B),EOMONTH(D$14,0))

needs to have double quotes around the column references , as in :

SUMIFS(INDIRECT("'" & $D$11 & "'!" & "$E:$E"),INDIRECT("'" & $D$11 & "'!" & "$A:$A"),$B83,INDIRECT("'" & $D$11 & "'!" & "$B:$B"),EOMONTH(D$14,0))

Narayan

Thank you for pointing that out. It looks like that cleared out the circular references.