Hi,
I have a main table 'Transaction Log' and a summary table 'End of Period', that essentially sums up a few columns in the main table.
When I add a new row (i.e. Row 13) in the 'Transaction Log' table, the formula in the 'End of Period' summary table (i.e. Cell C2) does not recognise this new row added.
Is this by design or did I enter the formula wrongly?
Please advise.
Thanks in advance,
Ray
Windows, Windows 10
Hi Ray,
that is by design.
You told Numbers to use the values from row 2 to row 12.
If you add a row 13 under row 12 it will ignore this new row.
If you would add a new row between 2 and 12 it would include this new row.
It is better to tell Number to use the complete column.
Therefor you select the letter of the column, B / C. Your formula will look like this.
This will include all new rows, no matter where they are added.
All rows that are not headers and / or footers will be used for the calculation.
Therefore it is important to define headers & footers.
Add or remove rows and columns in Numbers on Mac - Apple Support
https://www.youtube.com/watch?v=Vc5JmwCQiFk
Hope this will help
Regards Ralf
Hi Ray,
that is by design.
You told Numbers to use the values from row 2 to row 12.
If you add a row 13 under row 12 it will ignore this new row.
If you would add a new row between 2 and 12 it would include this new row.
It is better to tell Number to use the complete column.
Therefor you select the letter of the column, B / C. Your formula will look like this.
This will include all new rows, no matter where they are added.
All rows that are not headers and / or footers will be used for the calculation.
Therefore it is important to define headers & footers.
Add or remove rows and columns in Numbers on Mac - Apple Support
https://www.youtube.com/watch?v=Vc5JmwCQiFk
Hope this will help
Regards Ralf
Thanks Ralf.
Your suggestion to use only column references (that selects “all” values in a column) in the SUMIF formula solved the issue for me.
Perfect!
Thanks,
Ray
Formula in a summary table does not include new rows added to the main table
