Mar 14 2019 07:37 PM
Hi,
I've inherited a spreadsheet in my new job. If contains a very complex formula, most of which I can decipher except for one part.
There is a SUMIF statement where the range argument says:
'Actuals plus Adjustments'!$A:$A
I can't work our what or where that range is. The sheet contains several tabs, two of which are Actual and Adjustments.
Any thoughts on how I can track this down?
Mar 14 2019 10:33 PM
Solution