I have a cell, say A1, in what used to be Sheet1 but is now renamed Cat
I have another cell, say A2, in what used to be Sheet2 but is now renamed Dog
How do I multiply those two cells?
=PRODUCT(Cat! A1 * Dog! A2) gives me #NAME? error
and
=PRODUCT(Sheet1! A1*Sheet2! A2) also gives me #NAME? error
Thank you!