View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anvil22 Anvil22 is offline
external usenet poster
 
Posts: 23
Default countifs criteria

I am trying to count blank cells in as part of the second criteria.
=COUNTIFS(I2:I126,"reg",J2:J126," ")

I have used this =COUNTIFS(I2:I126,"reg",countblank J2:J126)
I can't get the number of blank cells.

can anyone help.
Thanks,
Dick