Hello,
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.
<tbody>
</tbody>
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>