Hi.
I'm working with a complex and therefore very long formula which (based on selected filtering) needs to use values in a certain column to calculate the results. I have created a combo box. Based on selected setting in this combo box, the formula needs to use the values in either column E, column F, column G etc. I would like to prevent a huge IF-based formula by combining this lengthy formula multiple times, therefore I have been looking into using a (text?) reference in the formula in stead.
For example: CEL A1 contains the column which is to be used in the formula (and is determined based on the selection in the combo box). I'm trying to come up with a formula which is based on the column which is mentioned in cell A1. The formula which is used to calculate the results would be something like =SUM('A1' + 1) in which the selection will determine if the formula will be =SUM(E1+1), =SUM(F1+1). SUM(G1+1) etc.
So far I have not had any luck in getting this to work. Any ideas on this (is this possible at all?).
Thanks in advance,
Eric
Bookmarks