Exasperated at a simple formula that will not return the correct answer. Using a SumIf function with named ranges for the selection and formula results, I have encountered an issue I have not seen before.
I have a range defined as Month1, I have referenced an entire column on an one of the worksheets in the file. I have seen that this name is valid for the entire Workbook, but when I change the cell references to A1:A200 on a sheet that does not contain the range, the range name reference is reported different on sheet b or sheet c. If I changed the range to A1:A200 it should keep that range for whatever worksheet I am on within the file, correct?
What am I missing?
Your assistance would be greatly appreciated.
Thank you in advance.
I have a range defined as Month1, I have referenced an entire column on an one of the worksheets in the file. I have seen that this name is valid for the entire Workbook, but when I change the cell references to A1:A200 on a sheet that does not contain the range, the range name reference is reported different on sheet b or sheet c. If I changed the range to A1:A200 it should keep that range for whatever worksheet I am on within the file, correct?
What am I missing?
Your assistance would be greatly appreciated.
Thank you in advance.
