3d array formula

O

oaishm

I have this formula, which works quite nicely

sum('usd begin:usd end'!m10)

to automate it, I started setting local names in the spreadsheet so I can
use the sheet more than once.

so sheet1!currency=sheet1!$b$3 for example.

So in sheet 1, a made this formula

=sum(indirect("'"&currency&" begin:"&currency&" end'!"&CELL("address",M10)))

alas, I have a ref error. I checked the string and it was fine. Any
suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to reference two cells to construct formula 1
Cell values to an array, then array transpose to another workbook 8
Search for multiple cells with a row for matching criteria, then sum up certain column 3
Selecting items from list and attaching ratios to selection 0
Opening different files one by one in same folder 1
A formula that's different on every row 2
VBA Pivot Table Error 1
Formula appearing as Value in Formula Bar 1

Top