ExcelBanter - using a dummy cell to reference a range into a formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - using a dummy cell to reference a range into a formula (https://www.excelbanter.com/excel-discussion-misc-queries/96883-using-dummy-cell-reference-range-into-formula.html)

talderman

using a dummy cell to reference a range into a formula

--
Tim

Peo Sjoblom

using a dummy cell to reference a range into a formula

If you put this in B1

A2:A10

then you can use

=SUM(INDIRECT(B1))

to sum that range

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

"talderman" wrote in message
...

--
Tim

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