Creating a Named Field with a formula in that cell

Hi,
I want to create a Named Field called “Formula-1”, which will have =SUM(C8,E7,E8,E9,H7,H8,J7,J8,J9,H9) in that cell.

My goal is to use this Named Field on multiple sheets where it would utilize that formula in that Named Field to return a value.

My question to the group, is it possible to have a formula in a Named Field that includes the equal sign as part of the formula?

Thanks for your reply.

Hi Xlent,
I want to thank you for replying to my post, it is very much appreciated.

I created the Named Field and I apply ! to the formula as noted in your post. When I added the Named Field to the respective sheet and hit the enter key, it returned the correct result in a quick flash, then it displayed the actual formula in the field instead of the result.

Is there something that I am doing wrong to stop it from displaying the results permanently? Thanks!

Hi XLent,
I found out what I was doing wrong. It worked as you posted. Thanks again for all of your help and expertise.