Is it possible to look for a specific column based on a column criteria and sum the column up to a specific row based on a row criteria?
<tbody>
</tbody>
Month = March (Column criteria)
Year = Yr. 3 (Row criteria)
I want a formula that will look for the March column and then sum that column up to the Yr. 3 row (50+60+80 only). Is this possible?
Jan | Feb | March | April | |
Yr. 1 | 10 | 20 | 50 | 70 |
Yr. 2 | 40 | 80 | 60 | 20 |
Yr. 3 | 30 | 10 | 80 | 40 |
Yr. 4 | 60 | 30 | 20 | 60 |
<tbody>
</tbody>
Month = March (Column criteria)
Year = Yr. 3 (Row criteria)
I want a formula that will look for the March column and then sum that column up to the Yr. 3 row (50+60+80 only). Is this possible?