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.