Dynamic Sum_Range within a 'Sumifs' formula help

[Matt76]

I'm struggling to get something to work and wonder if anyone out there could help me please?

I'm trying to have a dynamic sum_range within a 'Sumifs' calculation based on a user drop down. D11 is the drop down on the pic below which then using a vlookup returns the table column information in C11, i then use this in the 'sumifs' calculation which you can see in the formula bar.

as you can see on the pic below my formula is returning a #value!

Agent_DND is the name of the table of data.

any help would be appreciated.

Kind Regards

 

[Jonmo1]

Try changing the C11 in your formula to
INDIRECT(C11)