SOLVED
Home

SUMIF Query

%3CLINGO-SUB%20id%3D%22lingo-sub-369861%22%20slang%3D%22en-US%22%3ESUMIF%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369861%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20inherited%20a%20spreadsheet%20in%20my%20new%20job.%26nbsp%3B%20If%20contains%20a%20very%20complex%20formula%2C%20most%20of%20which%20I%20can%20decipher%20except%20for%20one%20part.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20a%20SUMIF%20statement%20where%20the%20range%20argument%20says%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E'Actuals%20plus%20Adjustments'!%24A%3A%24A%3CBR%20%2F%3E%3CBR%20%2F%3EI%20can't%20work%20our%20what%20or%20where%20that%20range%20is.%26nbsp%3B%20The%20sheet%20contains%20several%20tabs%2C%20two%20of%20which%20are%20Actual%20and%20Adjustments.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20thoughts%20on%20how%20I%20can%20track%20this%20down%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369861%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369882%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369882%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20it!!!%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369880%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369880%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fhide-or-show-worksheets-or-workbooks-a8f5977c-8f1a-4ce7-a45d-58cd2c7516de%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EMaybe%20the%20worksheet%20is%20hidden.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies