Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct problem | Excel Worksheet Functions | |||
SUMPRODUCT problem | Excel Discussion (Misc queries) | |||
SUMPRODUCT problem | Excel Worksheet Functions | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
SUMPRODUCT problem | Excel Worksheet Functions |