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”