View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Count with merged cells

hi, !

... if two cells are merged and something is entered in the merged cell
the count functions "see" the second cell as blank...


FWIW over "merged" CELLS, the cout functions DO NOT "see" the other cells as blank
THERE ARE (really) blank cells, since "merged cells" ARE NOT a "single" cell, but a range of CELLS

so, in order to not include "the other cells" (from a merged cells range) in a countblank function...
do NOT include "the other cells" within the function/formula, or even better, DO NOT USE "merged cells"
or... be aware that "merged cells" are not "single cells" (?)

hth,
hector.