This is my first post, and I'm a total noob in Excel
So, I want something that will lock a named range, which is for cell, it would be the $ sign, like: $A$1

Let's say I have dummy pivot table named Table_Flower.accdb4 with some column (left to right):
Name
Genus
Species
Color
Price
Then I made this formula in another sheet
=SUMPRODUCT(--(Table_Flower.accdb4[Name]=M$3)*--(Table_Flower.accdb4[Price]=$A7))/M$5
The problem is that, when I drag the formula to the left or right side, the named range also moves. It will be like
[Cell A1]
=SUMPRODUCT(--(Table_Flower.accdb4[Name]=M$3)*--(Table_Flower.accdb4[Color]=$A7))/M$5
[Cell B1]
=SUMPRODUCT(--(Table_Flower.accdb4[Genus]=N$3)*--(Table_Flower.accdb4[Price]=$A8))/M$6
[Cell C1]
=SUMPRODUCT(--(Table_Flower.accdb4[Species]=O$3)*--(Table_Flower.accdb4[Name]=$A9))/M$7
and so on

So, is there a way to lock the named range?