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 qual...
Excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor

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?

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Nov 04, 2018

    Select the cell. Press DEL key.

     

Resources