View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Suzanne Suzanne is offline
external usenet poster
 
Posts: 152
Default Getting true blank cell v ""

Thanks Gary!
--
Thank you -- Suzanne.


"Gary''s Student" wrote:

COUNTA() counts these pseudo-empty cells. If you want to exclude them from a
tally, use COUNT() instead.
--
Gary''s Student - gsnu200792


"Suzanne" wrote:

Good morning. In formulas i typically use a false value of "" to present or
store the result as a 'blank' cell. When i copy and paste the value of the
formulas and counta or countif range 0, Excel counts this cell. Should i
be using something other than "" if my result is false and want the cell to
be empty/truly blank?

--
Thank you -- Suzanne.