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
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