13 Replies Latest reply: Jul 4, 2013 7:28 AM by Yellowbox
Level 1

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

What error - I just changed one number?

MacBook Air, OS X Mountain Lion (10.8.4)
Solved by Yellowbox on Jul 4, 2013 3:13 AM Solved

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.

• Level 6
Mac OS X

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.

• Level 7

Sal,

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

Jerry

• Level 1

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

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

• Level 6
Mac OS X

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:

Пожалуйста, прости мои бедные русские,

С уважением,

Ян.

Regards,

Ian.

• Level 1

I've typed "f5" but Numbers changed it to 06.13 продвижение Sorry for you have to make unnesessary translation

Yes, all those cells in same Table

• Level 6
Mac OS X

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.

• Level 1

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

• Level 6
Mac OS X

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.

• Level 1

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

• Level 6
Mac OS X

Hi Salkat,

The formula in G8 works.

Your screen shot shows red triangles (syntax errors) in Column H.

=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.

• Level 1

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

• Level 1

Thenk you for your time and attention!

• Level 6
Mac OS X

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.