How to distinguish Empty cells from Zero

Question

I want to count a number of specific responses from a form where the response can be left empty, zero or any other number 'd'.

The following code:

var data = sheet.getRange("B2:L").getValues();

var d = 0;
if (data[i][j] == d){
    count++;
}

assumes that an empty cell == 0 is true, thus counting the wrong number of cells that actually hold the value zero

var d = 0;
if (data[i][j] != '' && data[i][j] == d){
    count++;
}

or any variation with != null / != "" does not seem to work for me

EDIT : Link to document. I think you can see the script if you make a copy.

Answer 1

When counting for the different d values, you need to check whether the objects in the array are string or number based:

for (var j=1; j<lastColumn-1; j++) {
  if (typeof data[i][j] !== 'string') {
    count[+data[i][j]][d]++;   
  }
}

Answer 2

Have you tried isBlank() function?

Answer 3

You can also use the following to determine empty, zero-value or 'else'.

 if (cell === "") // empty cell
     doEmptyCellStuff();
 else
 if (cell == 0)  // zero-value cell
     doZeroValueCellStuff();
 else
     dValueCellStuff();