I am trying to use a multiplication formula in a Countifs formula. It's not working, just returning 0. Can anyone see what I am doing wrong?
=COUNTIFS(BallByBallTable[inningsNo],1,BallByBallTable[ballRank],$A26,BallByBallTable[currentWkts],0,BallByBallTable[currentRuns],">(B26*5)")
Thanks
=COUNTIFS(BallByBallTable[inningsNo],1,BallByBallTable[ballRank],$A26,BallByBallTable[currentWkts],0,BallByBallTable[currentRuns],">(B26*5)")
Thanks