View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vic Vic is offline
external usenet poster
 
Posts: 117
Default count how many rows contain nonblank in column A and blank in colu

How do I count how many rows contain nonblank in col A and blank in col B? It
has to be a combination of both. If you find a nonblank in col A then check
col B in this row, if it is blank then count this row in.