Hi..

Go to Formulas----> Define Names

select the range and give an appropriate range...
you can also refer to excel inbuilt help...

after that when you are writing the formula..

use F3 button to paste the named range....


Don't forget to click *

For explanation give me a private message..
I will be explaining you everything at your Original
Thread...