How do I multiply across renamed sheets in Libre Calc

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!

try: =PRODUCT(Cat.A1;Dog.A2)

Formula syntax

PRODUCT function

1 Like