Countif, then average needed

Originally Posted by Cyants

Thanks HTH!
It is not working, but I think I know why. I am clicking on an empty cell below my pretest score column (B column) and placing the formula there.
I now question if that is correct. What cell receives the formula. (yet another dumb question)
thanks

the cell that types the formula gets the answer
see the amendment, check the ranges on your formula are all 2 to 110

hth = Hope this Helps
---

Originally Posted by Cyants

I love it when a plan comes together. Once I saw the pattern, life was good. I have written most of the formula and life is good.
thanks!!!!!

Good to see that it worked for you, and thanks for the response.

---