Forum Discussion
Solved
Prevent formula from changing range when cut and paste data
I have a workbook on a shared drive that about 10 people access and need to change specific data. In the workbook I have a range of cells representing beds in rooms. 5 rooms, 20 beds each, arranged i...
You might use the INDIRECT function:
=SUM(--ISTEXT(INDIRECT("C63:C82")))
or
=COUNTA(INDIRECT("C63:C82"))
You might use the INDIRECT function:
=SUM(--ISTEXT(INDIRECT("C63:C82")))
or
=COUNTA(INDIRECT("C63:C82"))
Thank you! After some googling, I figured the INDIRECT tag was going to be the key, but I couldn't for the life of me get the syntax down properly. I just tried it for one formula and it worked the way I need it to. I'll try it on the rest and put it in production and see how it works. But, it looks like this is the answer. Thank you very much.
