Inputting cell co-ordinates into cells

Originally Posted by Pepe Le Mokko

If there is nothing else in col A why not =SUM(A:A) ?

Thanks for the reply.

It's because I was only using that as an example.

In one tab I have lots of data. Products horizontally and prices vertically. As months go on, I get more pricing data and add values. The A column on this tab is dates. Maybe as time goes along I'll get more products too.

Then on another tab, I want to run different metrics, and especially I'm looking at calculating a whole load of metrics. Rather than create a new page per product, I'm hoping I can create one page, and then in the top left hand corner input some variables that allow me to change which product I'm calculating metrics on, and then as I add more data, either the formulas auto update (using offset function somehow) or I change a parameter in the top left hand corner of this tab which will then feed through.