Houzz Logo Print
myra7001

Excel question

18 years ago

I have a workbook that I am summing, let's say cell C12 in 14 other Workbooks. I put a plus in the Summary Workbook and then click on cell C12 in each of the 14 wookbooks with a + sign between each. It works just fine except I am not able to copy that formula in C13 through C20 because of the $ sign before the C and 12. It doesn't adjust the cells. How can I make the same formula above but not have the $ sign put into the formula automatically?

Myra

Comments (4)

Sponsored
AIS Renovations
Average rating: 4.5 out of 5 stars15 Reviews
Custom Craftsmanship & Construction Solutions in Franklin County, Ohio