Looking to count specific cells IF another cell is greater than or equal to 15

[HeRoseInThree]

The names I need to count are in column e and the vales of numbers are in r.
I tried =COUNTIF(E:E,"r2>=15")

Any help would be appreciated.

 

[Marcílio_Lobão]

HeRoseInThree, Good evening.

Try to use:

=COUNTIFS(E1:E1000,"<>0", R1:R1000,">=15")

Is that what you want?
I hope it helps.

 

[Damo71]

=sumproduct(--(e:e>0)*(f:f>15))

 

[HeRoseInThree]

I appreciate the quick reply, however it isn't quite what I am looking for.
I need to count the number of times a specific driver speeds at 15 mph or more.

 

[barry houdini]

To count the number of times that John goes at 15 mph or more

=COUNTIFS(E:E,"John",R:R,">=15")

so if you want to copy that down a column to get counts for each name then it can be

=COUNTIFS(E:E,E2,R:R,">=15")​

 

[Marcílio_Lobão]

HeRoseInThree,

Both of the suggested formulas work for this purpose.

Just set them with the desired parameter.

1) =COUNTIFS(E1:E1000, "SPECIFIC DRIVER NAME", F1:F1000,">=15")

2) =sumproduct((e:e="SPECIFIC DRIVER NAME")*(f:f>=15))

I hope it helps.

 

[HeRoseInThree]

That worked!!!! I LOVE this forum!!!
Thank you SO much!!!

 

[Marcílio_Lobão]

Pleased to have been able to help you.

Have a nice day!