View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ArthurN
 
Posts: n/a
Default Conditional counting

I wouldn't like to work with the numbers. I would like to find the number of
blank cells, say in column B, where the corresponding cell (row) in column A
wouldn't be empty:
A B
01/13 56
01/14
01/15 43
I can't use countblank(range) because I don't know the range, I know it
starts at b2, I don't yet know where it ends