Copying Excel Formula in different ranges [Closed]

Report
Posts
1
Registration date
Sunday May 19, 2013
Status
Member
Last seen
May 19, 2013
-
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
-
I want to copy a formula using different data ranges. The formula can't take dynamic range once copied.

Example

I want to use sumif formula from one sheet to another, but it takes source formula range rather than destination range. Is there any solution without VBA.

Kindly provide the suitable solution to the above.

Best regards,

Khurrum

1 reply

Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
460
Hi Khurrum,

To fix a cell reference in a formula you can use $ signs to make them absolute.

So dragging down A$1 won't change the cell reference.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!