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:$AI 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?
View best response
Maybe the worksheet is hidden.
That's it!!! Thank you!