Named Ranges in Excel 2007

[tomlinsn]

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.

 

[jim may]

Read through...

support.microsoft.com/kb/274504

 

[tomlinsn]

Thanks for the article link, but I guess my issue has more to do with the SumIF function as it is not returning the values expected.

 

[tomlinsn]

Re: Named Ranges in Excel 2007 -- SumIF

When I use named ranges for the Range, Criteria and Sum_Range, I get different values than when I use the specific cell references for the worksheet.

I have checked multiple times the defined ranges for each parameter and they appear to be correct, but I do not understand why I do not get the same results.

Any throughts would be greatly appreciated.
<!-- / message -->