Marcster
02-12-2019, 10:01 AM
I have the following formula:
=SUMIF(Table1[Column1],A5,Table1[[#All],[Column2]])
I would like the [Column2] part of the formula (Sum_range) to reference and use a cells value, example, if cell
A10 = AnotherColumn
I would like that in the formula.
This would mean I can get the Sum_range part of the table formula to be dynamic.
Thanks,
=SUMIF(Table1[Column1],A5,Table1[[#All],[Column2]])
I would like the [Column2] part of the formula (Sum_range) to reference and use a cells value, example, if cell
A10 = AnotherColumn
I would like that in the formula.
This would mean I can get the Sum_range part of the table formula to be dynamic.
Thanks,