SOLVED

SUMIF Query

Highlighted
New Contributor

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?

2 Replies
Highlighted
Best Response confirmed by Buff1969 (New Contributor)
Solution
Highlighted

@Detlef Lewin 

 

That's it!!!  Thank you!