View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how to account the number of cells which is bank and written?

Jack

=COUNTA(range) will count the non-blank cells in range.


Gord Dibben MS Excel MVP


On Tue, 8 May 2007 00:35:30 -0700, jack wrote: