Hi,
The following formula in cell T4 (see table below) sums rows in a table from Jan (January) up to Dec (December). However, I want to make the second sum term, Mar (March) in this case, variable, and refer to a value outside of the table. (I want to have the flexibility to change this from Jan to Dec.)
=SUM([@Name],Table3[@[Jan]:[Mar]])
-- removed inline image ---
The following formula in cell T4 (see table below) sums rows in a table from Jan (January) up to Dec (December). However, I want to make the second sum term, Mar (March) in this case, variable, and refer to a value outside of the table. (I want to have the flexibility to change this from Jan to Dec.)
=SUM([@Name],Table3[@[Jan]:[Mar]])
-- removed inline image ---
Last edited:
