Why is this indirect formula returning #Ref? =SUM(Indirect("'ACTUALS detail'!AM92:"&AT&"92,'ACTUALS detail'!AM93:"&AT&"93")
Maybe it's the fact that there are two references? Thanks.
Why is this indirect formula returning #Ref? =SUM(Indirect("'ACTUALS detail'!AM92:"&AT&"92,'ACTUALS detail'!AM93:"&AT&"93")
Maybe it's the fact that there are two references? Thanks.
I'm surprised it returns anything at all given that the parentheses are not paired.
Maybe you mean something like
Formula:Please Login or Register to view this content.
although as I said in your other post why do you need Indirect at all.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
This seems to be pretty much the same as you were asking here?
http://www.excelforum.com/excel-gene...-indirect.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins. It's a little different. The other pertains to a search and replace; this pertains to why the formula is/isn't working.
OK, did Richard's suggestion work for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks