Count and average formula needed to not count text field

Currently I have the following formula that adds all the totals in a range of cells and then divides them by how many cells entered to give me an average.
I want to keep this however I want the formula to not count or calculate into the avrage any cells in which an adjacent cell has a specific text entered EXP: “X”
=SUM(H18:H517)/COUNT(H18:H517)
H10 = Formula
H18:H517 = amounts entered
J18:J517 = area to enter text “X”

Try something like:

=AVERAGEIF(J18:J517,"<>X",H18:H517)

Also, if needed:

=SUMIF(J18:J517,"<>X",H18:H517)/COUNTIF(J18:J517,"<>X")

works great, thx