Circular Formula correction help needed

[KcrazyCowboy]

Hi Team,

I am trying to correct a formula that data from another tab and tallies it up into one cell for said date, but it keeps coming back as circular formula not sure what step i may be missing.

=SUMIFS('Planned Order Output'!$J:$J,'Planned Order Output'!$H:$H,$A4,'Planned Order Output'!$I:$I,BH$4,'Planned Order Output'!$G:$G,'Production Roll Up (NC)'!$E4)

 

[johnnyL]

You might want to mention which cell address you are trying to put that formula into.

 

[mikerickson]

You may also want to look at any formulas in the ranges on Planned Order Output that might have formulas that refer to the cell where you are putting the formula.

Also, what is this calculating? Is your logic of your desired result circular? If that's the case, then theres no formula that can implement it directly.

 

[KcrazyCowboy]

You might want to mention which cell address you are trying to put that formula into.

Sorry:
1. Planner Order Output

2.Production Roll Up (NC)

 

[mikerickson]

What cell are you putting that formula in?

 

[KcrazyCowboy]

What cell are you putting that formula in?

It is going into every cell below NA4, so from NA5 down

 

[mikerickson]

It looks like you should look to the formulas in Planned Order Output