I have data that's formatted as follows:

Col_AOntario | Col_BOntario1 | Col_C1 |

Ontario | Ontario1 | 1 |

Ontario | Ontario2 | 2 |

Ontario | Ontario2 | 2 |

Ontario | Ontario2 | 2 |

Alberta | Alberta1 | 3 |

Alberta | Alberta1 | 3 |

Alberta | Alberta1 | 3 |

Alberta | Alberta2 | 4 |

Alberta | Alberta3 | 5 |

Alberta | Alberta3 | 5 |

Manitoba | Manitoba1 | 6 |

Manitoba | Manitoba2 | 7 |

Manitoba | Manitoba2 | 7 |

Manitoba | Manitoba2 | 7 |

Manitoba | Manitoba3 | 8 |

Manitoba | Manitoba3 | 8 |

<colgroup><col><col><col></colgroup><tbody>

</tbody>

on another sheet, I am looking to add a sumifs type formula based on column A which sums the data in column C, but only for the first instance of whatever value is in column b. i.e. sum for Ontario should be 1+2 = 3. Sum for Alberta should be 12. Sum for Manitoba should be 21. Thank you in advance for any help!