I import a phone bill from a csv file, some little program downloadable from
internet where you can click option spreadsheet and save as csv file. Of late
they have changed the programm used to read the phone bill but procedure for
me remains the same, still save a csv file.......

Now the table inported seems complete identical to old one except now is my
sumproduct not working any more?

Once the data has been imported (I just copy and past csv file into a
sheet), the data needed is collected by a straight refference, ='Ebill'!A1
........
From this data additional data is generated checking wheter calls where
business or private related.

In my sumproduct check the call type en business/private..., you can guess
it breaks down cost

Importing the data previously there was not a single problems with the
sumproduct cells, all looked up columns ... and returned the value

Now with the newly imported file it doesn't want to work, all #N/A, and no
idea why. The import data is similar as previous (general, text etc) ...

What can be the problem?

Found it, was one #N/A in the data used to lookup.

"willemeulen" wrote:

I import a phone bill from a csv file, some little program downloadable from
internet where you can click option spreadsheet and save as csv file. Of late
they have changed the programm used to read the phone bill but procedure for
me remains the same, still save a csv file.......

Now the table inported seems complete identical to old one except now is my
sumproduct not working any more?

Once the data has been imported (I just copy and past csv file into a
sheet), the data needed is collected by a straight refference, ='Ebill'!A1
.......
From this data additional data is generated checking wheter calls where
business or private related.

In my sumproduct check the call type en business/private..., you can guess
it breaks down cost

Importing the data previously there was not a single problems with the
sumproduct cells, all looked up columns ... and returned the value

Now with the newly imported file it doesn't want to work, all #N/A, and no
idea why. The import data is similar as previous (general, text etc) ...

What can be the problem?