View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Stad Steve Stad is offline
external usenet poster
 
Posts: 14
Default count if for blanks with 'or'

Can you use the 'or' with a countif to count blanks -- if so can you tell me
how?
For example trying to count blanks in a column of data where the range, eg.,
b1:b100 is blank. ..criteria is something like <A or <1.