Formula works on all but one worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Schanks - 25 Mar 2008 17:55 GMT

I have the following formula:

=SUMIF(DST.txt!$A:$A,B4,DST.txt!$B:$B)

In my problem worksheet to resolves to 0.00. When I place this formula
in a new workbook it works fine. The cell is not set to text, it is
set to currency format.

If I change the formula to refer to itself rather than an external
workbook it works fine.

Reply to this Message

Pete_UK - 25 Mar 2008 18:20 GMT

I don't understand the DST.txt part - is this meant to refer to sheet
txt in file DST? If so, it won't work. Or is it to sheet DST.txt in
the same file? The correct syntax if it is in another file is:

'full_path[filename.xls]sheet_name'

The apostrophes are needed if you have any spaces in that string. If
the file is open, then you don't need the full_path part.

Perhaps the data in column B is really text values that just look like
numbers, or that you don't have a complete match in column A with what
you have in cell B4.

Hope this helps.

Pete

> I have the following formula:
>
[quoted text clipped - 6 lines]
> If I change the formula to refer to itself rather than an external
> workbook it works fine.

Reply to this Message

Bill Schanks - 25 Mar 2008 19:57 GMT

DST.txt is an open file. It is a text file that is opened to be able
to link to.

Also, I found that the formula will work if the lookup value is
'123-4', but if it is '1234' it doesn't.

> I don't understand the DST.txt part - is this meant to refer to sheet
> txt in file DST? If so, it won't work. Or is it to sheet DST.txt in
[quoted text clipped - 23 lines]
> > If I change the formula to refer to itself rather than an external
> > workbook it works fine.

Reply to this Message