KcrazyCowboy
New Member
- Joined
- Jun 13, 2016
- Messages
- 33
- Office Version
- 2010
- Platform
- Windows
- MacOS
- Mobile
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)
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)