That is a very good hint/reminder, Steve. I knew about this when staying within the same sheet; I hope it works for me.
TNX. Regards, Vince Sent from my iPad > On Jan 29, 2016, at 19:17, Steve Ahlers <sahlers...@yahoo.com.INVALID> 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 > > Another way of creating the formula is to type the = then click on the source > cell and hit return. > > Steve > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
