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,
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)
not working formula: =06.13 продвижение/СУММ(Конверсия :: E28:E31)
Where is 06.13 ? Is it G5 ?
=G5/SUM(First Table E28:E31)
What are we doing wrong?
The formula in G8 works.
Your screen shot shows red triangles (syntax errors) in Column H.
Your second formula should work:
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:
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.