View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marchettimama marchettimama is offline
external usenet poster
 
Posts: 1
Default Blanks counted when highlighting group of cells

When I highlight a group of cells that include values and blanks, the "count"
function that shows up at the bottom of the screen counts the blanks as well
as the values. I know if I use "text to cloumns" on the column, it will
clear out the blanks, but is there a faster way? I have alot of columns and
I'd hate to have to do "text to column" on each one. I only want to count
the values in each column.
--
mm