LinkBack URL
About LinkBacks
I have this long formula on Sheet4. The cells it needs to reference are on sheet Sheet3. How would I format this correctly?
Please Login or Register to view this content.
I have this long formula on Sheet4. The cells it needs to reference are on sheet Sheet3. How would I format this correctly?
Please Login or Register to view this content.
You would add the sheet reference followed by an ! sing in front of each range..
e.g. Sheet3!D104:H104
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
So there's no way to preface the formula by telling Excel that everything in this formula is from a different sheet?
I'm afraid not... you have to identify where each range is.
Thanks anyways!
You could use the MIN function rather than IF in your formula, thus:
MIN(SUM(D104:H104,D125:H125,D146:H146,D167:H167,D189:H189,D210:H210,D231:H231),40)
This will shorten the formula considerably (even with the addition of SHEET3! against each range).
Mark.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks