Google-sheets – How to make one cell correspond with another for google spreadsheet

google sheets

    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.

Best Answer

Maybe: 

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