Ohk, May be you are getting wrong results because of the same. correct the formula and try again or upload a sample book where it is actually happening (remove sensitive information)
You will find a icon(at the end) in the source tab, where you put the formula, in the name manager . Once you enter the formula click the icon and it will take you to the results if it shows correct results then your formula is correct.
Bookmarks