Hi! Wondering what the best way to sum a number of columns based on a particular cell which is dynamic.
<tbody>
</tbody>
Example below, the formula manually has E3 which is location of Mar in the data. But Mar will change by each instance so i want to be able to have the cell reference change based on a formula.
<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>Thanks!
I can use this formula when E3 is static, but wondering how to get E3 to be dynamic based off a cell value
<tbody> </tbody> |
<tbody>
</tbody>
Example below, the formula manually has E3 which is location of Mar in the data. But Mar will change by each instance so i want to be able to have the cell reference change based on a formula.
Jan | Feb | Mar | Apr | May | Jun | Jul | ||
Customer 1 | $ 100.00 | $ 80.00 | $ 75.00 | $ 125.00 | $ 150.00 | $ 110.00 | $ 25.00 | |
Cell reference | Result | |||||||
Mar | $ 255.00 | |||||||
<tbody> </tbody> | =SUM(OFFSET(E3,0,-3,1,3)) | |||||||
<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>