numbers
In numbers I have a table that contains some configuration values, I reference these in formulas but when I copy and paste the cells using the configuration values it breaks as it increments the cell position.
How can I copy and paste the cells but maintain the reference to the configuration value?
Thanks
The easiest way is to use "Conditional Highlighting..." found under the "Format" menu.
Select the cell you want to have blank as zero then select "Conditional Highlighting" you then set a highlight when the cell is equal to zero. Choose "Custom Highlighting" at the bottom of the style list and then you can set the text colour to white. A "blank" cell on zero.
It does work in iCloud Numbers:
Select the cell you want the result in: i.e D2 of "Juice and Beverages"
And then in the text field at the top of the page enter:
=SUM('Units Sold' :: B2)
Take note of difference in how I have written it and how you did. Which was you main problem.
When done, click the green tick button on the right. And you will see this as the end result.
You can see some documentation on some of the included Functions by clicking into a cell and then into the:
1, text filed above:
2, you can search for a formula.
3,insert a Function template into the text field.
4, see a description of the Function and scrolling down further in the description you will see examples.
Best Answer
You need to use the $ char e.g. like this:
=$D$3