Copying Excel Formula in different ranges

Closed
Report
Posts
1
Registration date
Sunday May 19, 2013
Status
Member
Last seen
May 19, 2013
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 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
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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