PDA

View Full Version : [SOLVED] Complicated formula, i'm at a loss



plasteredric
11-03-2017, 04:16 PM
I'm trying to work out a solution to combine formulas in two cells so I can do away with some columns and add in some variable.
The cell where the formula is required is "AI8", at the moment the formulas in columns X and Y work out a value which incorporates the variables in AG3:AG4. Then AI8 takes that value and multiplies it by the appropriate value in the 'points' table, and sums all the rows in the table.

I'd like to be able to take the values from the same column in the range AI3:AP11, rather than AG3:AG4.

Sheet attached if anyone can help.

SamT
11-05-2017, 02:20 PM
Moderator bump

Aflatoon
11-06-2017, 07:29 AM
I don't follow what you need. The formula in AI8 doesn't appear to use X or Y at all.

plasteredric
11-06-2017, 11:42 AM
I don't follow what you need. The formula in AI8 doesn't appear to use X or Y at all.

Doesn't matter, I managed to sort it