Solved
Problems with downloaded .csv - matrix sum problems
I have performed a study using qualtrics, collected all the results but realized after I had started that I needed some data I hadn't downloaded in the first place. So I downloaded the data from qualtrics in .csv-file, opened it in excel and was to merge the matrix from my previously downloaded data (in which I have had no problems in excel) and the new data-file. I figured the easiest way was to have the two matrix' in its own sheet and have a third sheet where I use a simple =matrix1A1+matrix2A2-formula. But when I do so I get #value! in the sum matrix.
I have tried a lot of different options:
- Formating the data as numbers
- =if(istext(A1);"";A1) and =if(istext(A1);0;A1)
- Paste special
- And so on
I attached the file here so a helpful soul can have a look at the problem.
Thanks for any tips available!
Best answer by PeeyushBansal
Formulas seems incorrect in your excel file like for B3 in sum you are adding b3 and b3 of matrix 1 and matrix2 respectively. And they are both blanks.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
