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.

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

Maybe:

=averageif(A:A,"Male",B:B)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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