On 1/29/2016 6:58 PM, Keith N. McKenna 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
Once I have changed the comma to a period within my originally entered
formula, all is working as expected here.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org