Forum Discussion

martin.lysvik's avatar
martin.lysvik
Copper Contributor
Nov 01, 2018

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!

 

 

Excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Nov 01, 2018

    Hi

     

    The empty cells in Matrix 2 are not empty but contain zero length text strings.

    So try:

    =SUM('Matrix 1:Matrix 2'!B3)

     

    • martin.lysvik's avatar
      martin.lysvik
      Copper Contributor
      Nov 04, 2018

      Thanks for you reply, when I copy paste the formula it works. I am interested in deleting the zero lengt text string, do you have a guide/link where that is explained?

Resources