I want to sum all "Apples" under the "Jan" Column in the following table. I want to make the formula dynamic by having the

**formula lookup the entire table**and select the correct columns and rows rather than using "Sumifs" on a per column basis. Any help will be appreciated.

The formula should add the items in RED.

Jan | Feb | Mar | |

Apples | 1 | 6 | 11 |

Oranges | 6 | 11 | 16 |

Apples | 11 | 16 | 21 |

Lemons | 16 | 21 | 26 |

<tbody>

</tbody>