Thread: non blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerald Gerald is offline
external usenet poster
 
Posts: 22
Default non blank cells

I am trying to subtotal a column and I get an error message stating that
excel can shift non blank cells. how can I bypass this error message to get
the subtotal for the column?