Try whether the below is returning the first item from the named range

'with file open
=INDEX(Pillars.xls!date_Jan,1)

--
Jacob


"Vixter" wrote:

Thanks for all your input and time. Nothing is working - and because I'm on a
network the location of the file is long.
What I've done is calculate the formula without the names (just as a range -
while Pillars.xls was open) and then I simply typed in the range names over
the cell ranges - seemed to have worked.
I'm still learning.
Thanks again.

"Jacob Skaria" wrote:

Try

'if open
=SUMPRODUCT((Pillars.xls!date_Jan=B15)*
(Pillars.xls!date_Jan<=B16),Amount_Jan)

'if Pillars.xls is closed
=SUMPRODUCT(('D:\Pillars.xls'!date_Jan=B15)*
('D:\Pillars.xls'!date_Jan<=B16),Amount_Jan)

PS: Make sure Amount_Jan is of the same dimension as the named range Date_Jan

--
Jacob


"Vixter" wrote:

I'm feeling thicker than two bricks. Can you put it simply?
The workbook that contains the names is called "Pillars" and the sheet the
data is in is called "Jan". Can you use the following formula to stick those
in?
=SUMPRODUCT((Date_Jan=B15)*(Date_Jan<=B16),Amount _Jan)
Sorry - I am still learning excel.
Let me know if I need to explain better?

"Jacob Skaria" wrote:

You need to mention the workbook name. Names collection represents all the
names in the active workbook. (names defined with the Workbookname and
"WorksheetName!" as prefix).

--
Jacob


"Vixter" wrote:

Hi Jacob, thanks but I can't seem to work it.
I basically need a sumproduct of "Amount" from the other workbook. (I'm
doing it between dates). In my workbook with the names I use the following
formula:
=SUMPRODUCT((Date_Jan=B15)*(Date_Jan<=B16),Amount _Jan)
I need to use the same formula but without just copying it from one workbook
to another.
Is this possible?
Thanks.

"Jacob Skaria" wrote:

The below would refer to the first cell of named range Name1 from saved
workbook Mybook.xls

=INDEX(MyBook.xls!Name1,1)

--
Jacob


"Vixter" wrote:

P.S. It's not just using the same name. I need to use the same ranges as the
two workbooks are connected.

"Vixter" wrote:

I have one workbook where I have named ranges.
Is it possible to somehow use those names in formulas in a completely
different workbook? Excel 2003.
Any help is appreciated.