Previous Topic Next Topic

Copying Excel Formula in different ranges

Closed
Khurrum Iqbal Posts 1 Registration date Sunday 19 May 2013 Status Member Last seen 19 May 2013 - 19 May 2013 à 16:44
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 21 May 2013 à 11:34
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
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
21 May 2013 à 11:34
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