Thread: Countif and
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hassan Hassan is offline
external usenet poster
 
Posts: 75
Default Countif and

Hi All,

How I count then no. of occurances in following condition

Status Speed

Harsh Braking 5
Driving 15
Harsh Braking 12
Harsh Braking 35
Harsh Braking 40
Driving 12
Harsh Braking 4
Harsh Braking 0
Driving 15

How I can count the No. of harsh Braking if speed is more then or equal to 10.

Thanks