amartino44
Board Regular
- Joined
- Dec 12, 2012
- Messages
- 56
Hello. I have these formulas (there are 100+ but all of the same pattern) down a column.
=SUM('ACTUALS detail'!AM72:AQ72)
=SUM('ACTUALS detail'!AM73:AQ73)
=SUM('ACTUALS detail'!AM87:AQ87)
=SUM('ACTUALS detail'!AM92:AQ92,'ACTUALS detail'!AM93:AQ93)
How can I do find and replaces to make the formulas like this:
=SUM(Indirect("'ACTUALS detail'!AM72:"&AT&"72")
and for the ones with multiple selections
=SUM(Indirect("'ACTUALS detail'!AM92:"&AT&"92,ACTUALS detail'!AM93:"&AT&"93")
I don't want have to do that manually for each cell. Thanks.
=SUM('ACTUALS detail'!AM72:AQ72)
=SUM('ACTUALS detail'!AM73:AQ73)
=SUM('ACTUALS detail'!AM87:AQ87)
=SUM('ACTUALS detail'!AM92:AQ92,'ACTUALS detail'!AM93:AQ93)
How can I do find and replaces to make the formulas like this:
=SUM(Indirect("'ACTUALS detail'!AM72:"&AT&"72")
and for the ones with multiple selections
=SUM(Indirect("'ACTUALS detail'!AM92:"&AT&"92,ACTUALS detail'!AM93:"&AT&"93")
I don't want have to do that manually for each cell. Thanks.