Countifs with Calculation

[andybason]

I have a Countifs formula that I would like to adapt to include a calculation.

=COUNTIFS(BallByBallTable[inningsNo],1,BallByBallTable[ballNumber],$A19,BallByBallTable[currentWkts],0)

I would like to add a criteria that says if BallByBallTable[runs] is equal to or greater than cell A10 plus 60 but can't work out how to do it.

Is it even possible?

Thanks

 

[Legacy 143009]

=COUNTIFS(BallByBallTable[inningsNo],1,BallByBallTable[ballNumber],$A19,BallByBallTable[currentWkts],0,BallByBallTable[runs],">="&$A$10+60)

This should work?

 

[Fluff]

How about

=COUNTIFS(BallByBallTable[inningsNo],1,BallByBallTable[ballNumber],$A19,BallByBallTable[currentWkts],0,BallByBallTable[runs],">="&A10+60)