External Cell reference Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-2633270%22%20slang%3D%22en-US%22%3EExternal%20Cell%20reference%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633270%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20working%20with%20some%20SUMIF%20and%20COUNTIF%20equations%20with%20external%20cell%20references%2C%20and%20for%20some%20reason%2C%20they%20are%20returning%20zeros%20when%20I%20know%20the%20equations%20or%20right.%20When%20I%20use%20these%20same%20equations%20in%20the%20same%20file%20as%20the%20source%20data%2C%20they%20return%20the%20expected%20values%2C%20but%20once%20I%20move%20them%20into%20the%20other%20file%2C%20and%20use%20the%20same%20exact%20formulas%20just%20with%20external%20references%2C%20they%20return%20nothing%20but%200's.%20Can%20anyone%20help%20me%3F%20Is%20there%20something%20I%20must%20change%20with%20my%20formula%20to%20make%20it%20work%20with%20external%20links%3F%20Need%20help%20ASAP%2C%20thanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2633270%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2633654%22%20slang%3D%22en-US%22%3ERe%3A%20External%20Cell%20reference%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2633654%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1125216%22%20target%3D%22_blank%22%3E%40Jknisl%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBetter%20to%20check%20exact%20formula.%20In%20any%20case%20another%20file%20shall%20be%20opened%20working%20with%20SUMIF()%20and%20COUNTIF().%20In%20general%20SUMPRODUCT()%20works%20better%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I've been working with some SUMIF and COUNTIF equations with external cell references, and for some reason, they are returning zeros when I know the equations or right. When I use these same equations in the same file as the source data, they return the expected values, but once I move them into the other file, and use the same exact formulas just with external references, they return nothing but 0's. Can anyone help me? Is there something I must change with my formula to make it work with external links? Need help ASAP, thanks in advance

1 Reply

@Jknisl 

Better to check exact formula. In any case another file shall be opened working with SUMIF() and COUNTIF(). In general SUMPRODUCT() works better here.