SOLVED
Home

SUMIF Query

Buff1969
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
Solution

@Detlef Lewin 

 

That's it!!!  Thank you!