i've copied cell with formula to another cell. Edit new cell (changed the range). Syntax error.

Yellowbox New South Wales, Australia
Hi salkat,
More information will help. What is the formula? From which cell did you copy and to which cell did you paste it? What did you change after copying?
A screen shot of a small part of your Table will help (remove all personal details first).
Regards,
Ian.

Like (0)


Sal,
Copy and Paste the two formulas from your Numbers document to your post here so we can compare them.
Jerry

Like (0)


working formula: =05.13 продвижение/СУММ(Конверсия :: E24:E27)
not working formula: =06.13 продвижение/СУММ(Конверсия :: E28:E31)

Like (0)


Yellowbox New South Wales, Australia
Hi Salkat,
I used Google Translate from Russian to English:
продвижение/СУММ(Конверсия
promotion / SUM(conversion
Thank you for teaching me some Russian!
I think that the problem lies in the Cell changes:
E24:E27 to E28:E31
Please post a screen shot to show those Cells. Are they all in the same Table?
I am struggling here. I need to know how many Sheets (Листы) and how many Tables (Таблицы) are in your document. Please post a screen shot of your Sheets Pane, for example:
Пожалуйста, прости мои бедные русские,
С уважением,
Ян.
Please forgive my poor Russian,
Regards,
Ian.

Like (0)



Yellowbox New South Wales, Australia
Hi Salkat,
I've typed "f5" but Numbers changed it to 06.13 продвижение
I see! You have ticked Numbers > Preferences > General > Use Header cell names as references.
working formula: =05.13 продвижение/СУММ(Конверсия :: E24:E27)
Cell G8 of the second Table:
=F5/SUM(First Table E24:E27)
=3 700/(7+9+3+4)
=3 700/23
=160.86956
=161 (rounded).
I agree.
not working formula: =06.13 продвижение/СУММ(Конверсия :: E28:E31)
Where is 06.13 ? Is it G5 ?
=G5/SUM(First Table E28:E31)
=4 000/(3+0+0+0)
=4 000/3
=1 333.333
What are we doing wrong?
Regards,
Ian.

Like (0)


wrong is 'syntax error' instead of calculation
If I create the new formula  everything is ok, but if I edit copied formula  I get syntax error instead of calculation

Like (0)


Yellowbox New South Wales, Australia
Hi Salkat,
This works:
=F5/SUM(First Table::E24:E27)
If you copy and paste, where are you pasting?
If you paste into another Column, the formula will change both F and E (relative references)
Perhaps absolute references ($) will help.
Regards,
Ian.

Like (0)


Thanks Ian. I know about '$', but problem in other thing: any edited formula gives syntax error. $ is not always helps. For instance, first formula need to be =F5/SUM(First Table::E24:E27), second  =E5/SUM(First Table::E28:E32). So I have to edit formula... and getting an error

Like (0)


Yellowbox New South Wales, Australia
Hi Salkat,
The formula in G8 works.
Your screen shot shows red triangles (syntax errors) in Column H.
Your second formula should work:
=E5/SUM(First Table::E28:E32)
E5 contains 5 331
E28 contains 3
E29 to E32 appear to be empty. Even if they contain spaces, SUM will ignore them and treat them a zero. So:
=E5/SUM(First Table::E28:E32)
=5 331/(3+0+0+0+0)
=5 331/3
=1 777
What are the cell formats in Column E ?
If you like, click on my name to get my email address and send me the document. Make a copy first, and then delete all personal information.
Regards,
Ian.

Like (0)


Thank you, Ian, turning off Numbers > Preferences > General > Use Header cell names as references checkbox was helped to resolve the problem  now I can edit cells

Like (0)


Thenk you for your time and attention!

Like (0)


Yellowbox New South Wales, Australia
Hi Salkat,
Thank you for your reply. It will help other people. I enjoyed working through this problem. I am glad that you can now edit.
Regards,
Ian.

Like (0)
