0 
    A      B       C        D   
1|Male  |  5   |Male avg|   8   |
2|Female|  4   |        |       |
3|Female|  8   |        |       |
4|Male  |  9   |        |       |
5|Male  |  10  |        |       |

How do I make it so that google spreadsheets sums the cells that are beside a cell with "male" then takes a average out of 10? If possible, I would like an answer where the values change automatically when I fill in a new row.

Improve this question
1
  • Just to clarify, you want it to sum all cell with Male next to them and then divide by 10?
    – Punchlinern
    Commented Mar 1, 2015 at 18:57

1 Answer 1

Reset to default
1

Maybe: 

=averageif(A:A,"Male",B:B)
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.