Excel: Formula "breaking" when moving sheets

I have the following formula in each sheet in a workbook: =SUMBYCOLOR(A35,INDIRECT("o35:"&$B$6&"35")) which works great (thanks to the help received on the forum yesterday :) ) The only problem is the project I am doing will involve me moving the sheets around (basically it is live document in the business so I can only amend the worksheets in small batches, and there are alot of changes needed to get them consistent.) When I move the worksheets I had completed, the above formula returns the error NAME!. I did change the workbook name as I resaved it - would this be what is causing the error? IF so, can I fix/avoid it? Many thanks again Andrea

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of July 22, 2015.

For more resources for Microsoft Excel