TNX Keith: I am rather sure that your info will help me; I am certain that a new script for reading vision is what I also need, since having cataracts re moved!
Regards, Vince Sent from my iPad > On Jan 29, 2016, at 18:58, Keith N. McKenna <[email protected]> wrote: > > 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 >
