I'm using the formulato give the sum of collumn C of the sheet specified in collum A (of this sheet).
Please Login or Register to view this content.
Works like a charm except when the name of the sheet has a space or - in it. It just gives the REF error.
I have tried sticking brackets in but it's no use.
Any advice would be greatly appreciated.
Last edited by exarranum; 03-14-2013 at 12:31 AM.
hi exarranum. a little confused with this; you want to return the SUM but use MAX? to deal with spaces, put in single quotes before & behind the sheet name:
=MAX(INDIRECT("'"&A1&"'!c:c"))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Perfect,thanks! Sorry about the confusion. It was a typo as I'm using max AND sum for calculating a few different things (max for most recent date, sum for total stock etc).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks