Countif and

[Hassan]

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

 

[Lars-Åke Aspelin]

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

Try this formula:

=SUMPRODUCT(- -($A$2:$A$10="Harsh Braking"), - -($B$2:$B$10>=10))

Hope this helps / Lars-Åke

 

[Hassan]

Thanks Lars
Its working fine.

Thanks again

Try this formula:

=SUMPRODUCT(- -($A$2:$A$10="Harsh Braking"), - -($B$2:$B$10>=10))

Hope this helps / Lars-Ã…ke