如何在Excel公式中对已命名范围进行子集划分?

I have a named range in excel, of one column and 40 rows. I would like to take the product of the last 36 elements of that column vector. I cannot get index or offset to work. I would think this would do it, but I get a reference error:I have a named range in excel, of one column an