Countif, then average needed

Originally Posted by Cyants

I must admit that I do not use excel much, but I MUST finish this analysis tonight and have not been able to get a simple formula to work. Here are my questions. (If I can get one formula to work, I can rewrite it to find others. PLEASE, someone give me the correct formula.
Question

1. Pre test score average by grade (7 & 8)
(column B2:B110 are the pre test scores and column E2:E110 either lists a 7 or an 8 for grade)

2. Pre test score average by gender (Male & Female)
(column G2:G110 list either Male or Female)

3. Pre test score average by gender and by grade
(I think this will require an "countif + countif" command)

Thanks, I know it is supposed to be Christmas, but I need to get this figured out. HELP me PLEASE

Hi,

With a 7 in D2 and a 8 in D3, the formula

=SUMPRODUCT(--(C$2:C$10=D2)*B$2:B$10)/SUMPRODUCT(--(C$2:C$10=D2))

formula fill down another cell will give either.

make the range 110 (shown as 10) in all 3 places.

=SUMPRODUCT(--(G$2:G$10="Male")*B$2:B$10)/SUMPRODUCT(--(G$2:G$10="Male"))

will also help you

hth

---
amended $ in B$

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.

---