Copying Excel Formula in different ranges

Closed
Khurrum Iqbal
Posts
1
Registration date
Sunday May 19, 2013
Status
Member
Last seen
May 19, 2013
- May 19, 2013 at 04:44 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- May 21, 2013 at 11:34 AM
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

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
May 21, 2013 at 11:34 AM
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
0