Home

External Reference issue with SUMIF

%3CLINGO-SUB%20id%3D%22lingo-sub-432814%22%20slang%3D%22en-US%22%3EExternal%20Reference%20issue%20with%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-432814%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20main%20spreadsheet%20that%20I%20want%20to%20use%20SUMIF%20formulas%20to%20read%20data%20in%20other%20spreadsheets%20on%20the%20same%20network%2Fsame%20drive.%20Every%20time%20I%20try%20to%20reopen%20the%20main%20file%20the%20values%20are%20%23VALUE%20until%20I%20reopen%20the%20source.%20Is%20there%20are%20way%20to%20fix%20this%20error%20without%20keeping%20all%20the%20linked%20spreadsheets%20open%20or%20breaking%20links%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-432814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-433401%22%20slang%3D%22en-US%22%3ERe%3A%20External%20Reference%20issue%20with%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433401%22%20slang%3D%22en-US%22%3EUse%20SUMPRODUCT%20instead%20of%20SUMIF.%3C%2FLINGO-BODY%3E
spreadsheetdreams
Occasional Visitor

I have a main spreadsheet that I want to use SUMIF formulas to read data in other spreadsheets on the same network/same drive. Every time I try to reopen the main file the values are #VALUE until I reopen the source. Is there are way to fix this error without keeping all the linked spreadsheets open or breaking links?

1 Reply
Use SUMPRODUCT instead of SUMIF.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Teams Calling - Dial pad missing
Chris Cooper in Microsoft Teams on
73 Replies