We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
There is currently 1 person viewing this thread.
Want to count how many times a player serves consistently quickly ( in the 130-139 range ), but not outrageously quickly in a database.
The formula I have is currently:
=COUNTIF(D2:DZ2,">129")-COUNTIF(D2:DZ2,">139")
Is there a way to shorten the formula above by using wildcards perhaps, something like
=COUNTIF(D2:DZ2,"13?")
which doesn't work, but you know what I mean.
The formula I have is currently:
=COUNTIF(D2:DZ2,">129")-COUNTIF(D2:DZ2,">139")
Is there a way to shorten the formula above by using wildcards perhaps, something like
=COUNTIF(D2:DZ2,"13?")
which doesn't work, but you know what I mean.
sort by:
Show
per page
Replies: 12
|
By:
=COUNTIFS(d2:dz2,">129",d2:dz2,"
|
|
By:
=COUNTIFS(d2:dz2,">129",d2:dz2,"
|
|
By:
ffs ..next bit s/b "
|
|
By:
keeps deleting
|
|
By:
less than 140
|
|
By:
=SUMPRODUCT(--(D2:DZ2>6),--(D2:DZ2
|
|
By:
Did not come out right, how it was typed
|
|
By:
=SUMPRODUCT(--(D2:DZ2>129),--(D2:DZ2 less than 140))
Put in where less than |
|
By:
<
|
|
By:
Thank you for the help Compound Magic and getintheir, on this and other threads like it. I'm really Blue SquÄre standard at excel compared to you guys, but because I'm a civil servant and can do VLOOKUPs and SUMIFs, my managers seem to think I'm an excel god . .
 |
|
By:
bongo
"....but because I'm a civil servant........" You may be in violation of the Electronic Media Policy by disclosing such information. Be careful. They have eyes everywhere and are paranoid regarding disclosure of information. |
|
By:
If they think you can actually do something then absolutely no chance of promotion. You are stuck there for life.
|