Just drag down (or copy) like a normal formula, Excel shall update relative
references alike in case of regular formulae.

Regards,
Stefi

€žJeff€� ezt Ã*rta:

Hello,

I am using this formula to multiply all the digits in an integer:

=PRODUCT(VALUE(MID(C55,ROW(A1:OFFSET(A1,LEN(C55)-1,0)),1)))

So far so good...

But I want to copy this array formula for a large range of cells, each
with a different integer. But my understanding is that an array
formula must be the same for the range of cells. How can I get it to
update to different cells (C55 in the above formula, the next one is
C64, e.g.) like a regular formula?

Thanks,
Jeff