Countif and

  • Thread starter Thread starter Hassan
  • Start date Start date
H

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
 
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
Click to expand...


Try this formula:

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

Hope this helps / Lars-Åke
 
Thanks Lars
Its working fine.

Thanks again

Lars-Ã…ke Aspelin said:
Try this formula:

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

Hope this helps / Lars-Ã…ke
Click to expand...
 
Back
Top