Trying to use INDIRECT Excel function and I keep getting an error

Question

I am trying to do an MBA for grocery data.

I need to compute the Lift between combinations of items.

My code is returning a #REF error.

In 2 places.

I am using this code:

=SUM(INDIRECT("groceryBin["&FQ6&"]"))/$FQ$2

groceryBin is the name for the cells corresponding to the order number (row) and items (column).

I get a #REF error

Next, I am trying to count the number of times that items are purchased together from the table.

I am using this code, but it's not working:

=SUM((INDIRECT(FQ6)=1)*(INDIRECT(FW6)=1))

Any advice on how to fix it?