Excel range dropdown SUM using INDIRECT
In Excel, to sum range based on the selection of drop-down list, I use data validation, the SUM and the INDIRECT function.
In Excel, to sum range based on the selection of drop-down list, I use data validation, the SUM and the INDIRECT function.