I am trying to work out a formula that will take a number and add it to other numbers in the same row, though only if the column meets a certain criteria. Then average the numbers based on the occurrences of the criteria. Did that make sense?

Bob | 11 |

Sarah | 9 |

Bob | 3 |

John | 5 |

David | 6 |

Sarah | 2 |

David | 3 |

Sarah | 4 |

<tbody>

</tbody>

So I am trying to get a formula that will show Bob = 7, Sarah = 5, John = 5, David = 4.5

I am working in a spreadsheet with just about 300 entries with 10 to 20 new entries each month so by the end of the year I should be close to 400 entries.