View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darrren Darrren is offline
external usenet poster
 
Posts: 2
Default COUNT IF - 2 conditions

2 columns.
column 1 needs to be searched for a certain numerical value (a 6 digit code)
column 2 is a series of numbers and needs to be searched for a value greater
than 30

i.e. would want to to bring up how many examples of 666666 have a value of
greater than 30