SHOP PRODUCTS
Houzz Logo Print
myra7001

Excel question

myra7001
15 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)