[Solved] Pulling Detail from Second Sheet

Discuss the spreadsheet application

[Solved] Pulling Detail from Second Sheet

Postby KeithOO » Fri Nov 22, 2019 6:59 pm

I have a Summary cell in a Spreadsheet and a separate Column of figures which are typed (all within the same sheet). The Summary cell automatically shows the last figure in the Column. The figure changes each month when another figure is typed into the Column.
The following is used for the Summary cell:
=INDEX(AM9:AM4996;COUNT(AM9:AM4996))
This works fine but now we wish to change it so that the typed Column will be in another Sheet (in same document). The original Column will remain but will pull its entries automatically from the typed Column in the new Sheet.
That works fine but the Summary cell does not, i.e. it will not now pull the figure from the original Column. It would be fine to point the Summary cell to the Column in the new Sheet but I cannot make it work. The new Sheet is named MONTH END and I have tried to prefix the above but no joy, i.e.
='MONTH END'.INDEX(AM9:AM4996;COUNT(AM9:AM4996))
I assume it should work and I am doing something wrong.
Thanks for any suggestions.
Last edited by robleyd on Sat Nov 23, 2019 12:38 am, edited 2 times in total.
Reason: Add green tick
Open Office 4.1.7 MacOS 10.13.6
KeithOO
 
Posts: 114
Joined: Sat Jun 15, 2013 8:34 am

Re: Pulling Detail from Second Sheet

Postby FJCC » Fri Nov 22, 2019 7:15 pm

Try
Code: Select all   Expand viewCollapse view
=INDEX('MONTH END'.AM9:AM4996;COUNT('MONTH END'.AM9:AM4996))
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7436
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Pulling Detail from Second Sheet

Postby KeithOO » Fri Nov 22, 2019 7:55 pm

Perfect. Thanks very much.
Open Office 4.1.7 MacOS 10.13.6
KeithOO
 
Posts: 114
Joined: Sat Jun 15, 2013 8:34 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 12 guests