I am trying to find out how many times a certain varible appears in a list of equations

Eg
how many times AF3 apprears in column A
how many times AN3 appears etc

column A
=IF(AND(AF3=1,AN3=1,AP3=1),1,IF(AND(AF3=-1,AN3=-1,AP3=-1),-1,0))
=IF(AND(AD3=1,N3>O3,AY3=1),1,IF(AND(AD3=-1,N3<O3,AY3=-1),-1,0))
=IF(AND(AD3=1,AV3=1,AI3=1,AF3=1),1,IF(AND(AD3=-1,AV3=-1,AI3=-1)-1,0))


I used the following on the basis of using this formula repeatedly ie in the case below for AF3 and then so on inserting a different "*varible*" each time

so i would have

=COUNTIF($A$10:$A$12,"*AF3*")
=COUNTIF($A$10:$A$12,"*AN3*")
=COUNTIF($A$10:$A$12,"*AP3*")

etc

but when idid it for the 1st one it seems only to pick out one occurance per row if it is there ie in the above it gave a value of 2 instead of 3 i tested it putting AF3 3 times across a row and it only gave 3 as the and also taking one af3 out of the 1st equation it still gave 3

any ideas,
thank you