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
