Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses