Formula with named cell

I have a column in which cell name of A1 is “strt” and A100 is “endd”. I want to add from A1 through A100.
When I type in the formula =sum(strt:endd), it is adding only the values in A1 and A100. I want the values from A2,A3.. A99 also in the sum. I wish to work with named cells only.

Please help

@TMS .. Yes. i tried and it works. Perhaps, Excel won't highlight all the elements when the sum column is double-clicked (like when sum(A1:A100) is typed . Hence, I got confused.
thanks for the reply.

In B1 put:

=CONCATENATE(TRANSPOSE(A1:A100)

Don't press enter yet.
Select the TRANSPOSE(A1:100) portion and press F9
Now remove the {} brackets then press ENTER

I hope this works for you

@BillyRaySpivy i wanted to work with named cells. As i am relatively new to named cells, the non-highlighting of cells from A1 through A100 confused me. The problem is solved
Thanks for the reply.

Glad you got it working