Thread: Applying Name Range Excel 2007

Hi, I hope somebody can assist me with named ranges.

I am trying to apply 3 named ranges to formulas but upon applying keep getting the error message that Microsoft Office Excel cannot find any references to replace.

I have attached a small workbook that shows the issue.

Please can somebody tell me why applying names to my formula is causing this error ?

Thank you

Steve