New Posts For Thread: Excel query, another onehttps://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-oneWant 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 formulaIf they think you can actually do something then absolutely no chance of promotion. You are stuck there for life.https://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448686121#448686121If they think you can actually do something then absolutely no chance of promotion. You are stuck there for life.Sat, 22 May 2010 16:27:51 -0500bongo"....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.https://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448681273#448681273bongo"....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.Sat, 22 May 2010 15:50:16 -0500Thank you for the help Compound Magic and getintheir, on this and other threads like it. I'm really Blue Squhttps://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448654293#448654293Thank you for the help Compound Magic and getintheir, on this and other threads like it. I'm really Blue SquSat, 22 May 2010 12:39:02 -0500https://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448573133#448573133Fri, 21 May 2010 20:21:26 -0500=SUMPRODUCT(--(D2:DZ2>129),--(D2:DZ2 less than 140))Put in where less thanhttps://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448573057#448573057=SUMPRODUCT(--(D2:DZ2>129),--(D2:DZ2 less than 140))Put in where less thanFri, 21 May 2010 20:20:50 -0500Did not come out right, how it was typedhttps://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448572053#448572053Did not come out right, how it was typedFri, 21 May 2010 20:11:28 -0500=SUMPRODUCT(--(D2:DZ2>6),--(D2:DZ2https://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448571913#448571913=SUMPRODUCT(--(D2:DZ2>6),--(D2:DZ2Fri, 21 May 2010 20:10:15 -0500less than 140https://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448561425#448561425less than 140Fri, 21 May 2010 18:31:08 -0500keeps deletinghttps://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448561321#448561321keeps deletingFri, 21 May 2010 18:30:27 -0500ffs ..next bit s/b "https://community.betfair.com/general_betting/go/thread/view/94082/24843673/excel-query-another-one?post_id=448561241#448561241ffs ..next bit s/b "Fri, 21 May 2010 18:29:56 -0500