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?
|
|
0
|
|
|
|
Reply
|
 Utf
|
3/1/2010 10:24:01 AM |
|
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?
>
>
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
3/1/2010 11:58:01 AM
|
|
|
1 Replies
185 Views
(page loaded in 0.09 seconds)
Similiar Articles: find text string to use in a sumproduct - microsoft.public.excel ...Hello, I would like to create a sumproduct function that checks whether column a ... The problem is column f contains such things as "TEST", > "test(A)", "test-20/1 ... multiple sumproducts and now formula is too long - microsoft ...ok guys. here is my problem. i am using several sumproducts and adding them together to get a value. note that the range I am suming is the same ... SLOPE function malfunctioning - microsoft.public.excelI am having a serious problem with excel. For my research, which I am supposed ... in B2 to B10 (and with no blank cells!) the slope of the fit line is =SUMPRODUCT ... Modify SUMIF to find data range in addition to value - microsoft ...Aren't you going to have the same search problems? Remember, you're also saying it ... then the date in A1, then something like >> this should work >> >> =sumproduct ... SUMPRODUCT with date range - microsoft.public.excel.worksheet ...Excel: Sum for a date range, sumproduct, date sales sumproduct, date sales, b2: SUMPRODUCT formulas are always good for multi-criteria sum/count problems. Sumproduct cell reference vs embedded "values" ...... corresponding column position is a blank cell, this formula works: =SUMPRODUCT ... Date Values by Specified Date Criteria Problem ... criteria in the form of a number ... Sumproduct with sumif over mutiple worksheets - microsoft.public ...Sumproduct/sumif/indirect Across Multiple Workbooks, Worksheets, Multiple Criteria - My original Problem ... particular cell (D:12 through to D:87) over the three sheets ... lookup to see if multiple values exist - microsoft.public.excel ...Hi, I am faced with this problem. I have data as follows: Col1 Col2 Col3 ... Try the following formula in Cell E2 =IF(SUMPRODUCT((A$2:A$5=D2)*(C$2:C$5<>VLOOKUP ... How to check a condition and write another cell - microsoft.public ...... text length, I just simply use LEN() function combined with IF and no problem with this. 2. In Sheet4 and Sheet5, for checking to array, I used: =ADDRESS(SUMPRODUCT ... Adding an additional forumula to my SUMPRODUCT formula - microsoft ...... and now formula is too long - microsoft ... ok guys. here is my problem. i am using several sumproducts and adding them together to get a value ... I suggest a SUMPRODUCT ... Excel - Sumproduct - problem solved ... - Free Excel HelpSumproduct - problem solved - Free Excel Help ... SUMPRODUCT for Bank Deposit Calculation - See how to enter number of bills in deposit and quickly calculate the ... Excel - Sumproduct Problems - I wrote a sumproduct... - Free Excel ...Sumproduct Problems - I wrote a sumproduct formula that works Code ... - Free Excel Help SUMProduct formula problems - Microsoft AnswersJeeped, I didn't see any text in column AJ, but nevertheless, I went with your SUMIF formula and it worked great. Thank you for that. Last question is for the ... Sumproduct in VBA Type Mismatch problem ExcelIf desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the ... An Excel 2007 Tutorial: Use Excel's SUMPRODUCT to Summarize ...Taking SUMPRODUCT to the Next Level. So, to test whether Excel is having problems coercing TRUE and FALSE to 1 and 0, I merely needed to force the coercion within the ... 7/20/2012 9:54:37 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
66 followers. 