The example can be easier to understand if it copy in a spreadsheet in target.Create a book or a spreadsheet in target.Select the example in the subject of Aid. It does not select the headed ones of row or column. To select an example of the AidPress CTRL+C.In the spreadsheet, it selects the A1 cell and it presses CTRL+V.In order to alternate between seeing the results and of seeing the formulas that give back the results, it presses CTRL+ `(serious accent) or, in the menu Tools, it chooses Audit of formulas and, next, it clicks in Way of audit of formulas.
TO B
1 23
2 66 IT FORMULATES: =CONTAR.BLACO (A2: B2)
3 25 RESULT: the empty cells serian 8.
4
5 27
6
It counts the empty cells in the previous rank.