Dear Excelists,
I'd appreciate your help with the following problem:
I have an Excel worksheet with some numbers in columns E and F (see the screenshot).
In my cell B2, I would like to calculate the sum of the numbers in one of the two columns. I indicate the relevant column in cell B1 (in this example I selected column E)
How do i modify the default SUM formula, so that it looks up cell B1 and uses the content of this cell as column in the formula?
Thanks for your help!
I'd appreciate your help with the following problem:
I have an Excel worksheet with some numbers in columns E and F (see the screenshot).
In my cell B2, I would like to calculate the sum of the numbers in one of the two columns. I indicate the relevant column in cell B1 (in this example I selected column E)
How do i modify the default SUM formula, so that it looks up cell B1 and uses the content of this cell as column in the formula?
Thanks for your help!