ExcelBanter - Copy Function Without Range Update

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copy Function Without Range Update (https://www.excelbanter.com/excel-worksheet-functions/65495-copy-function-without-range-update.html)

[email protected]

Copy Function Without Range Update

I have a rather complicated SUMIF fcn, which I want to drag/copy to
other cells without changing the various ranges used. So far, I've had
to go back and modify after each copy. Any suggestions?

All times are GMT +1. The time now is 11:13 AM.