I have a formula that references
A1:B5 for instance, the result lives in any arbitrary cell, say
D1. How do I copy and paste the same formula, referencing the same values as in
D1, through the entire column
D? For some reason, I can't find this answer anywhere.
If I select
D1 for instance, and click the bottom right, and drag to use auto-fill, it seems to increment the
A1:B5 values which ruins the results.