D
dreamz
to make this easier, i'll start off with an example.
i have two named ranges, and i want to find the sum of thei
differences. to do this, i use an array formula:
{=sum(a-b)}, which gives a single number.
now, how do i do calculations on that result without having to do
calculation on that particular cell? in other words, i want to write
long formula in a single cell that operates on that array result.
thanks
i have two named ranges, and i want to find the sum of thei
differences. to do this, i use an array formula:
{=sum(a-b)}, which gives a single number.
now, how do i do calculations on that result without having to do
calculation on that particular cell? in other words, i want to write
long formula in a single cell that operates on that array result.
thanks