So i have a several cells with numerical entries and I want to have each one add its value to a specific cell so I can change that specific cell and have it reflect in all the other cells. I know I can do the $ between the letter and number, but I would have to manually to put them in, in each cell because when I do the whole grab the corner of the box and pull it down it just replaces all the numerical values with the value of the cell I pulled down. How can I get excel to lock each value that is already in the cell l so I can add it to another cell?

Could you please post a small sample with an example of what you want to achieve? I don't understand your problem