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

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.

Sal,

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

Jerry

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.

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.

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.

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.

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.