When cells are merged, only the upper left cell holds the value. COUNT is not counting cells, it is counting the number of cells with numbers; therefore, 10 not 19. You merged A5:A7 and entered 78 in the merged area, but only cell A5 is holding the 78 so count is one not three.