Vince wrote: > > > > I am using AOO Calc vers 4.1.2 and Win 8.1x64 (file name is 2016 My > Bowling Score Data.ods). > > I want to "automatically transfer" the data that is typed/entered into > Cell M342 of the Sheet named: 2016 Scores into Cell D6 of the Sheet > named: 2016 Match Play. > > The Cell M342 data is calculated by the formula: > =SUM(C342:K342), > which yields a result of 386. > > I have entered: > =($'2016 Scores',M342) > into Cell D6 of the Sheet named: 2016 Match Play. > > Cell D6 results in Err: 508. > > Is this error due to an improper typography? Any suggestions are welcomed. > > VinceB. > > > > Vince;
The formula =$'2016 Scores'.M342 should be the formula you need. The 508 error comes from the use of the parents, and the separator in Calc is a . rather than the , used in Excel. Hope this helps Keith
signature.asc
Description: OpenPGP digital signature
