Number of horses in a race

[christine]

Hi all, I'd like to alter a formula to only place a bet if there are at least 5 horses in the race. I currently use this formula, which relates to laying the 2nd favourite at a certain number of seconds before the off, but don't know how to amend it or even if it can be amended:

=IF(AND($T$1>88,$T$1<91,AA5=2,H5<6.1,$F$2="",COUNT(T$5:T$55)=0,$E$2="Not in Play"),$T$3,"")

Many thanks in anticipation,
Christine

[Kentucky]

Hi Christine
Just add to the formula

=IF(AND(COUNTA(A$5:A$34)>5,$T$1>88,$T$1<91,AA5=2,H5<6.1,$F$2="",COUNT(T$5:T$55)=0,$E$2="Not in Play"),$T$3,"")

Kentucky

[doris_day]

Just a small amendment as Christine wanted the lay to be triggered if there were at least 5 runners.

COUNTA(A$5:A$34)>5 should read COUNTA(A$5:A$34)>=5

[christine]

Many thanks for the advice!