Referencing values of user defined value outside of a table

[tombomb]

Hi there,

I've tried to give an example of the problem in the attached image.

Capture.JPG

Intro
I have a table - the grey cells make up the header row.
It contains some data (columns 1-4)
To the right of this I'm showing Values depending on certain criteria (Columns S32, S33, S34)
The variable X is a user-defined within Name Manager - lets call the formula "Result"

The problem
In the totals regiion, I want to say:
=sumifs(Result,Table1[S32],(some criteria))

The value of Result is different in each cell.

I get a #Value error on "Result".
Essentially excel doesn't recognise I only want the sum of "Result" from each single column.

I've also tried SUMPRODUCT to the same effect.

The Question
How do I reference a user defined value within a specific range?
I want to be able to say something like:
(Table1[S32].Result)
But this doesn't work.

Any help much appreciated.