I need a cell that contains the sum of all the objects from another table. Can this table be placed in the cell, so when I need it from a cell, can I expand and collapse the table?
In a word, no, you can not even be able to complete the range on the table Set a cell to be equal to and it should be Ctrl + Shift + Enter (for example: = {A1: B10} ) that cell is still the top of the table -The value of the left value will be used when used in sources.
Just take the table and paste it in a hidden range or sheet.
Comments
Post a Comment